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.