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)
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!
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.
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
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")))
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)
So helpful, thank you for making my life easier
The VStack solution help me alot, thanks! :-)
This saved my life!!!!!!!! Thank youuuuuuuu
life saver. thank you
Amazing!!!🎉
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!
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?
thank you !
How would you return a zero if the filter isn't used?
does this work when I'm working on only 2 sheets? 1 is for the data and the other one is the summary sheet.
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.
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
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")))
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?