* Advanced Functions * COUNTIF (Tutorial 7 & 9) * Advanced Functions * COUNTIF (Tutorial 7 & 9) COUNTIF Range (R) Criteria (C) Range (R) Criteria (C) Components =COUNTIF(R,C) =COUNTIF(F2:F101,B4) =COUNTIF(R,C) =COUNTIF(F2:F101,B4) NOTES: RANGE- Data where we are looking for the matches to count CRITERIA – Cell that contains the information that match that you are looking for RANGE- Data where we are looking for the matches to count CRITERIA – Cell that contains the information that match that you are looking for
{}