writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 8:
Line 8: − +
no edit summary
COUNTIF(r, c)
COUNTIF(r, c)
For example, COUNTIF(A1:A8,"JOHN") returns the number of cells in the range A1 through A8 and which matches 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".
*Criteria containing numbers can be expressed as 66, "66","<=66", ">=66", "<>66" etc.
*Criteria containing numbers can be expressed as 66, "66","<=66", ">=66", "<>66" etc.