Counting Cells

[markinblackuk]

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

[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 the range A1:A21

HTH

[Roger Govier]

Hi

Try
=COUNTIF(A:A,"="&B1)

Regards

Roger Govier


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

[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 the criteria by which you want to count is in cell b2, the formula in cell c3 will be:

=COUNTIF(A2:A10,B2)

(=countif(range,criteria)

hope this helps!

thanks,

MoonWeazel