Counting Cells

M

markinblackuk

I wish to count the cells in one column using criteria in another
column. The criteria is in Text form. Any help Please!!! :cool:
 
S

swatsp0p

You don't give enough details to truly understand your need. However
this may steer you in the right direction:

=COUNTIF($A$1:A21,"="&B1)

will count the number of times the value in cell B1 appears in th
range A1:A21

HT
 
M

MoonWeazel

Hi there,

I think you need to use countif.

so, if your list of things you want to count is in A2:A10 and th
criteria by which you want to count is in cell b2, the formula in cel
c3 will be:

=COUNTIF(A2:A10,B2)

(=countif(range,criteria)

hope this helps!

thanks,

MoonWeaze
 
Top