Calculating total amount of sales for each salesman

E

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. :
 
B

BenjieLop

Exedate said:
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. :)
Click to expand...

Try this ...

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

Regards
 
Top