Count Cells in Range Containing Specific Value

[Johnatha]

Hello,

I would like to know a simple macro that can count the number of cells in a certain column containing a certain value. Then, place that count on a cell on somewhere on my active worksheet. For example, count the number of cells in column 3 containing the word "ABSB" then place that count in a cell somewhere (see example table below).

Thanks



date
place
thing
person


21
alabama
ABSB
jim


22
alabama
ABSB
fred


20
alabama
ABSB
george


26
philly
CD
Jeremy

[Aussiebear]

Look up the sumproduct function

[JKwan]

put the formula onto a cell

=SUMPRODUCT(--(C2:C5="ABSB"))