Calculating total amount of sales for each salesman

[Exedate]

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

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

Any help will be greatly appreciated. :

 

[MrShorty]

Would the COUNTIF function work for you

 

[Exedate]

Yes it did.

Thankyou very much

 

[BenjieLop]

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

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

Any help will be greatly appreciated.

Try this ...

=COUNTIF(H7:H100,\"=\"&J7

Regards

 

[Roger Govier]

Hi

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