- COUNTIF( range, criteria )
- =COUNTIF(A2:A7, D2)
- =COUNTIF(A:A, D2)
- =COUNTIF(A2:A7, ">=2001")
- You can also use a named range in the COUNTIF function
- =COUNTIF(family, D2)
- =COUNTIF(family, ">=2001")
- To use a cell reference in the criteria
- =COUNTIF(C4:C19,">="&A1)
No comments:
Post a Comment