Forum Discussion
Returning a sum based on multiple columns
Hi jasontindal
Alternatively if you run Excel 2021 or 365 - no helper column:
in F3:
=SUM( FILTER(Table1[amount], (TEXT(Table1[column1],"MMMM") = F$2) * (Table1[type] = E3), 0) )
THANK YOU. I do not think the correct file was uploaded.
1. on the 'month overview' page, when entering the month from drop-down box C6 and year C7, it will return the sum in C9 and C10 respectively. maybe how c6 and c7 look needs to be modified. this type of formula and sheet is out of my wheelhouse. I just know the end result. lol.
2. on the 'transactions' page, why do the drop-down boxes not automatically come down (without dragging the corner) when you start typing on the next line?
there should be a file uploaded for today. with 2-11-2024 in name
I do not think the correct file was uploaded Thank you for the waste of time
#1 On the 'MONTH OVER VIEW-MAIN PAGE' sheet, should the Category, SubCat & Amounts be based on twhat's selected re. MONTH & YEAR?
#2 On the 'Transactions' page, why do the drop-down boxes not automatically come down (without dragging the corner) when you start typing on the next line? Probably due to this:
(something I'm not gonna fix on your behalf sorry - your application)
#3 Do you run Excel 2021 or 365?