Using this formula
=sumproduct(--(sheet1!A2:A3000="APPLE")*(sheet1!A2:A3000="DECEMB ER")
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.

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))
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Tigerxl" wrote:

Using this formula
=sumproduct(--(sheet1!A2:A3000="APPLE")*(sheet1!A2:A3000="DECEMB ER")
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.

Thank you much.

"Sheeloo" wrote:


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))
-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Tigerxl" wrote:

Using this formula
=sumproduct(--(sheet1!A2:A3000="APPLE")*(sheet1!A2:A3000="DECEMB ER")
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.