Sumifs across multiple sheets

[cogswel__cogs]

Hi,

Need to develop new summary page using sumif or sumifs over multiple sheets.

I have already set up sumif with list of sheets to calculate. (example below)
=SUMPRODUCT(SUMIF(INDIRECT("'"&Z2:Z4&"'!B3:b1000"),A9,INDIRECT("'"&Z2:Z4&"'!G3:G1000")))

This works fine
I could concatenate the 2 columns and use sumif again for the other calculation I was going to do as its only two columns.

I was just wondering can sumifs do similar across tab calculations or is only available for SUMIF?

 

[cogswel__cogs]

I wrote a Sumifs fomula using same sumproduct technique and it worked so I guess it is no problem.

Still wondering if processing time wise if since it was only two columns if concatenated sumif would work faster than sumifs statemnet.

 

[Aladin Akyurek]

I wrote a Sumifs fomula using same sumproduct technique and it worked so I guess it is no problem.

There shouldn't be a problem with that...


=SUMIF(B3:B1000,A9,G3:G1000)

and

=SUMIFS(G3:G1000,B3:B1000,A9)

are identical, expectedly also performancewise.

Still wondering if processing time wise if since it was only two columns if concatenated sumif would work faster than sumifs statemnet.

Sometimes it's a good practice to trade off memory against speed. Concatenated ranges have this effect.