Try using mapflo for data analysis instead of Excel. Get started for free.


Summary

COUNTIF formula counts the number of occurrences of a value in a column (data range).

Syntax

=COUNTIF(“range”,”value”)

In the example below, the formula in cell E2 is =COUNTIF(A2:A7,”T-shirts”) which returns the value 2 as “T-shirts” occurs twice in the range A2:A7.

Notes:

  • COUNTIF is not case sensitive.
  • COUNTIF can reference:
    • a number: =COUNTIF(C2:C7,10) returns 1
    • a string: =COUNTIF(A2:A7,”Shorts”) returns 2
    • a cell reference: =COUNTIF(A2:A7,A3) matches to Sandals and returns 2
    • a math operator: =COUNTIF(C2:C7,”>6″) returns 3
    • multiple wild characters: =COUNTIF(A2:A7,”S*”) matches to Sandals and Shorts and therefore returns 4 [where * denotes zero, one or multiple characters]
    • single wild characters: =COUNTIF(A2:A7,”*sh?rts”) matches to T-shirts and Shorts and therefore returns 4 [where ? denotes a single character]

 

Using mapflo with COUNTIF

If you like Excel then you’ll love mapflo. mapflo puts data through a flow. It’s easy to add a column that is COUNTIF using the Rank & Partition Node.

Using the same Rank & Partition Node you can RANK, SUMIF, AVG, MINIMUM AND MAXIMUM.

No copying down formulas; no worrying about change in dataset size.

Get started with mapflo for free.