Search for answers to your questions by entering keywords below, or look through our knowledge base.
Welcome to 'Sikkhon' User Forum
Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users.
You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.
COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition. For example, you are preparing a report and want to count how many sales invoices were greater than 400. Use the COUNTIF function to count greater than 400.
COUNTIF(range, criteria)
It has two arguments where range describes the range of cell/s to count and criteria explains the condition or criterion for counting.
Check the The following example:
You have created a sheet like below. and want to count how many rows here greater than 400
Just simple select the cell where you want to show the result and write the function =COUNTIF(C4:C9,">400") and press enter
Done! The answare will show 4,
The range of cells have been selected as C4:C9 and the condition is “greater than 400”.
Note that the operator (i.e. “>”) and the conditional value should always be enclosed in double quotations.
COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition. For example, you are preparing a report and want to count how many sales invoices were greater than 400. Use the COUNTIF function to count greater than 400.
COUNTIF(range, criteria)
It has two arguments where range describes the range of cell/s to count and criteria explains the condition or criterion for counting.
Check the The following example:
You have created a sheet like below. and want to count how many rows here greater than 400
Just simple select the cell where you want to show the result and write the function =COUNTIF(C4:C9,">400") and press enter
Done! The answare will show 4,
The range of cells have been selected as C4:C9 and the condition is “greater than 400”.
Note that the operator (i.e. “>”) and the conditional value should always be enclosed in double quotations.
Check the attached file.
Thanks
Attachments (1)
how to use c....xlsx
8.92 KB
0 Votes
0 Comments
Login or Sign up to post a comment