Sumif with multiple criteria across multiple sheets|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi! Could you help me with this problem?

I've got data in the same format on mutiple sheets. I want to use the sumif function with multiple criteria across all sheets based on the data i have in row 1.

I have a formula that works with a single criteria, however when i try to use multiple criteria it fails.

Here is the formula I've tried to use:

=SUMPRODUCT(SUMIF(INDIRECT(sheets&"!"&"1:1”), $E$1:$E$4,INDIRECT(sheets&"!"&"2:2"))).

(I named a range sheets, that contains all the names of my sheets.)

My overall goal is this:

i have monthly data for a year in each sheet, and i have cells on top month1; month2 etc. 

I want a cumulated number for each row till a certain month. ( For example I'd like to sum the first three months) and i want it to be changeable. (Next month i need the first 4 months)

Could you help me with the formula, or do you have any other idea not using VBA?

Thank in advance!

Daniel