|
SUMPRODUCT
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. |
SUMPRODUCT
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. |
SUMPRODUCT
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. |
| All times are GMT +1. The time now is 04:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com