countif

R

Roger

Hi there!
I have a spreadsheet wiht 5 colums; I want to count how many times a product
appears on column E, only IF cells on column A= 1000.

Anyone?
regards,
 
R

Roger

Hi there,

Many thanks for your help, but the formula is returning wiht 0(zero), value
- Is there a specific place I should write the formula?
regards,
Roger
 
D

Dave Peterson

Don't put the formula in A1:A2000 and not in E1:E2000.

But do make sure you change "<product>" to the real name.

If this doesn't help, post back the formula you used.
 
R

Roger

Once again many thanks for your help.

The formula I have used is :
=SUMPRODUCT(--(A3:a2002=109266),--(e3:e2002="AS400"))
The result in the cell is zero, however when I press the fx on the formula
bar, the correct number appears.

Best regards,
Roger
 
R

Roger

Dave,

Its ok now...not sure what happened! Anyway...thank you ever so much for
your help and time!
Best Regards,
Roger
 
Top