=Count(?)

[pnwood]

I have a coulmn with many values, I need to count all of the instances of one value.

Any Ideas?

Thanks for the Help

-- Pete

[swatsp0p]

use this formula, adjusting range to match your data's range:

=COUNTIF(E11:E17,n) where n is the value to count or a cell reference that contains the value to count

To count the number of times 95 occurs in a list in range E11:E17:
=COUNTIF(E11:E17,95) or
=COUNTIF(E11:E17,C12) where C12 contains 95

HTH

Bruce