SUMPRODUCT

[Tigerxl]

Using this formula
=sumproduct(--(sheet1!A2:A3000="APPLE")*(sheet1!A2:A3000="DECEMBER")
that will give me how many APPLES in DECEMBER
I replaced them for "1" and "1999" in order to give me:
how many "1" ocurred in "1999" and it gives me zero.
I'm guessing it works different with text( "APPLE","DECEMBER")
than with numbers ("1","1999").
How can I put it?
Thank you.

 

[Sheeloo]

You should not put quotes around numbers...It should be like
=SUMPRODUCT(--(Sheet1!A2:A3000=1)*(Sheet1!B2:B3000=1999))

Also both conditions refer to the same column? Is that what you want?

It is better and more flexilbe to put the number in a cell, say D1, and
refer to the cell like this
=sumproduct(--(sheet1!A2:A3000=D1))

 

[Tigerxl]

Thank you much.

You should not put quotes around numbers...It should be like
=SUMPRODUCT(--(Sheet1!A2:A3000=1)*(Sheet1!B2:B3000=1999))

Also both conditions refer to the same column? Is that what you want?

It is better and more flexilbe to put the number in a cell, say D1, and
refer to the cell like this
=sumproduct(--(sheet1!A2:A3000=D1))