SUM Across Multiple Sheets with Criteria | How to SUMIF Multiple Sheets in Excel | 3D SUMIF

[@andreasrom6812]

The VStack solution help me alot, thanks! :-)

[@thepinkythepink]

So helpful, thank you for making my life easier

[@baarg8672]

you are the best!! literally ive seatched all the internet (bing) and only here ive found multiple solutions even for 365 version, kudos! and be safe! let, vstack and filters is what i needed)

[@edenworkaferahu9755]

This saved my life!!!!!!!! Thank youuuuuuuu

[@swathirufina]

life saver. thank you

[@davidtitz2346]

Hi, can indirect function use multiple range references? To be able to take data from more columns? For example I2:I10 and I20:I30 and J2:J10 and J20:J30? Hope that makes sense

[@nataliewinn1695]

Amazing!!!🎉

[@SaudiDoor-x9s]

thank you !

[@ezbrown]

This is great! Is it possible to use the vstack across a number of different workbooks with the same structure rather than sheets in one workbook?

[@PeanutandChiquis]

How do we add using SUMIFS with multiple criteria? I dont have Excel 365, your formula worked for a single criteria but I got stuck with those that have more than one criteria please help thanks!

[@baarg8672]

cant make programmable sumif range with indirect function: two cells representing start sheet and end sheet but it counts only that two sheets but not all inbetweens

[@Herocooper1111]

How would you return a zero if the filter isn't used?

[@monicasalvarez]

This worked for my row one. But going down it (I typed each formula separately, did not copy down) only pulls from one sheet even tho I select multiple sheets.

[@miracleboi7336]

does this work when I'm working on only 2 sheets? 1 is for the data and the other one is the summary sheet.

[@cnix217]

This only works with number format and not general and it still adds values if the include cell is blank. Anyone figure out how to fix these?

[@nicolefloyd2358]

Hi I have a question related to this video please. How do I add in additional criteria? I need to look across all months per category, per property for income and expense. For example if Rent is for property EP17 and has money in income track to the income column on summary sheet, but if in expense track to the expense column. I have 3 properties and 6 categories and a tab for each month. V2:V13 is my month sheets Column D is the category and A4 is the category on the summary tab Column C is the property # EP17,EP50,SK356 Column F is the income Column G is the expense =SUMPRODUCT(SUMIF(INDIRECT("'"&$V$2:$V$13&"'!D3:D1000"),A4,INDIRECT("'"&$V$2:$V$13&"'!F3:F1000")))