Forum Discussion
Solved
Excel SUMIF function with multiple tables
Hello! I'm looking for some help with the SUMIF function. I have a spread sheet with multiple tables and I need to be able to add up all numbers from a specific year from all the tables. I ...
Same Detlef's formula, only to 'exclude' columns with amounts
=SUMPRODUCT((YEAR($E$8:$AL$31*(MOD(COLUMN($E$8:$AL$31)-COLUMN($E$8),3)=0))=A15)*($F$8:$AM$31))
Hi Lidia
=SUMPRODUCT((YEAR($E$5:$W$28)=A12)*($F$5:$X$28))
I just tried this and it's not working for me, I get #NUM! instead. Any other suggestions? I should mention that in the attached spreadsheet it works, but when I try to apply it to another spreadsheet that has dollar values instead of a quantity it stops working.
Thanks!
I can only provide a formula based on your uploaded file and not on your not-uploaded file.
I have attached the spreadsheet where I am trying to make it work.
Thank-you for all your help so far!!
Same Detlef's formula, only to 'exclude' columns with amounts
=SUMPRODUCT((YEAR($E$8:$AL$31*(MOD(COLUMN($E$8:$AL$31)-COLUMN($E$8),3)=0))=A15)*($F$8:$AM$31))