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))
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))
- It worked!! Thank-you!
Or covering the error.
{=SUM(IFERROR((YEAR($E$8:$AL$31)=A15),0)*($F$8:$AM$31))}
