Calculating total amount of sales for each salesman

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.

Would the COUNTIF function work for you?

Yes it did.

Thankyou very much.

Hi

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

--
Regards
Roger Govier
"Exedate" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>