Hi

One way would be
=SUMPRODUCT(--($H$7:$H$100=J7)*1)

--
Regards
Roger Govier
"Exedate" wrote in
message ...

I need help trying to find a formula for calculating up an occuring
number in a specific column.

An example being that if I need to find out how many times the number
"230.28" occurs in column H, which formula would I use? I was trying to
use =lookup(J7:this being the cell in which the number I need to see how
many times occurs is:,$H$7:$H$100) but obviously this doesn't calculate
up how many times it occurs in the column.

Any help will be greatly appreciated. :)


--
Exedate
------------------------------------------------------------------------
Exedate's Profile:
http://www.excelforum.com/member.php...o&userid=23812
View this thread: http://www.excelforum.com/showthread...hreadid=374652