COUNT FORMULA???

[psd364]

I need to use a formula to find out how many times the value in B2 appears in
column B.

 

[Lars-Åke Aspelin]

I need to use a formula to find out how many times the value in B2 appears in
column B.

Try this formula:

=COUNTIF(B:B,B2)

or, if you don't have Excel 2007, use this

=COUNTIF($B$1:$B$65536,B2)

Hope this helps / Lars-Åke

 

[Tom Hutchins]

I need to use a formula to find out how many times the value in B2 appears in
column B.

 

[Tom Hutchins]

Try
=COUNTIF(B:B,B2)
in any cell not in column B on the same sheet.

Hope this helps,

Hutch

 

[Shane Devenshire]

Excel 2003 does allow full column references with the COUNTIF function.

 

[Shane Devenshire]

Be careful B2 is in the range B:B so you will be counting the criteria cell
of the COUNTIF function, do you really want to do that?

 

[Lars-Åke Aspelin]

Excel 2003 does allow full column references with the COUNTIF function.

Thanks for pointing that out. I wasn't sure so I gave an alternative
solution too, just in case full column reference was not allowed.

Lars-Åke