Reference the same cell range on multiple sheets in a SUM.IF function

[iKoenvD]

Hi,

I have multiple sheets (jan, feb, mar). They all have a column (A) with (random)account numbers and a column (B) with values. I want to make a new sheet where for every account number there's a total value from all the sheets combined. So far i've got

=SUM(SUM.IF(jan!$A$2:$A$6,$A2,jan!$B$2:$B$6),SUM.IF(feb!$A$2:$A$6,$A2,feb!$B$2:$B$6),SUM.IF(mar!$A$2:$A$6,$A2,mar!$B$2:$B$6))

But this is not so elegant, especially since the real file is much more complex and has of course 12 sheets (for every month). I tried making a list of all the sheets (C1:C3) and then

=SUM.IF(INDIRECT("'"&C1:C3&"!$A$2:$A$6"),$A2,INDIRECT("'"&C1:C3&"!$B$2:$B$6"))

But this doesn't work.
I hope I explained it coherently. Any ideas?

 

[arthurbr]

You can always merge all the sheets with Power Query (Get & Transform) and apply a SUMIF function or a Pivot Table

 

[iKoenvD]

I'm not sure how that works. Excel says I would have to install some extra software. I would rather not if there is another way.