SUM IF Function from 25 sheets

[aravindhan_31]

Hi,

I have some 25 sheets in a workbook where I need to sum based on a criteria
I have attached the sample file for reference:

Regards
Arvind

[yurttas]

Hi,

I have some 25 sheets in a workbook where I need to sum based on a criteria
I have attached the sample file for reference:

Regards
Arvind

Your file attached.

.

[DonkeyOte]

see: http://www.mcgimpsey.com/excel/threedsumif.html

SUMPRODUCTS are generally best avoided if used in large volumes and/or when used in Volatile context (ie using INDIRECT)

Personally I would advise you create a list on sheets Test1:Test6 that correlates to the list on Master File, eg:

Group sheets Test1:Test6, then:

Test1!AA1: ='Master File'!A2
copy down

then

Test1!AB1: =SUMIF(F:F,$AA1,H:H)
copy down

Then, ungroup sheets and set:

'Master File'!B2: =SUM(Test1:Test6!AB1)
copy down

Less elegant than Sumproduct but significantly more efficient when the former is to be used en masse or Volatile.

[stanleydgromjr]

aravindhan_31,

See the attached workbook "SUMIF thru sheets - aravindhan_31 - SDG10.xls" with macro "SUMIFSheets".

Then run the "SUMIFSheets" macro.