writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 10:
Line 10: + + + + Line 18:
Line 22: − − *Special characters such as '*', '?', '~' can be used in the criteria field to match a certain sequence of characters.
no edit summary
COUNTIF(r, c)
COUNTIF(r, c)
COUNTIF(1..1000,">500") ''returns 500'' as a result.
COUNTIF(1..1000,"<=10") ''returns 10'' as a result.
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 that match with the text "JOHN".
*Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.
*Combination of functions can also be used as COUNTIF(A1:A3,"Red")+COUNTIF(A4:A7,"Orange") etc.
*COUNT() can be used to count the number of cells in the given range except logical values, error values and text.
*COUNT() can be used to count the number of cells in the given range except logical values, error values and text.