Hard to explain with words here what I'm struggling with. Perhaps example in attached file is clear enough?
Need to cross check with different sheet in the workbook before doing the sum in the main sheet.
Hard to explain with words here what I'm struggling with. Perhaps example in attached file is clear enough?
Need to cross check with different sheet in the workbook before doing the sum in the main sheet.
Sheet1
B8=IF(Sheet1!$A8<>"",SUMPRODUCT(SUMIF(Sheet1!$F$1:$Y$1,Sheet2!$A$2:$A$11,Sheet1!$F8:$Y8)),"")
Copy down
Wonderful! Thanks a lot!
Last edited by Cuni; 02-03-2023 at 11:47 AM.
B8=IF(Sheet1!$A8<>"",SUMPRODUCT(SUMIF(Sheet1!$F$1:$Y$1,Sheet2!$A$2:$A$11,Sheet1!$F8:$Y8)),"")
My formula works
your formula
=SUMPRODUCT(SUMIF(Sheet1!$F$1:$Y$1,Sheet2!$A$2:$A$11,Sheet1!$F$8:$Y$27)) ? not work
One more question if I may. How do I calculate all the rest of products that do not match the criteria?
I tried in column C with "<>"&Sheet2!$A$2:$A$11 but it's not working it seems. It should be 100 not 1045. See attached.
Sheet1
C8=SUMPRODUCT((ISNA(MATCH(Sheet1!$F$1:$Y$1,Sheet2!$A$2:$A$12,0)))*(Sheet1!F8:Y8))
Copy down
Last edited by CARACALLA; 02-03-2023 at 12:25 PM.
Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks