One way:

=SUMPRODUCT(--(A1:A2000=1000), --(E1:E2000="<product"))

http://www.mcgimpsey.com/excel/doubleneg.html


In article ,
"Roger" wrote:

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.