Forum Discussion
Solved
Returning a sum based on multiple columns
HELP PLEASE. I am trying to return the sum of numbers in a column based on the first two columns. Three columns total.
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) )
I think i was over thinking it. i have revised the spread sheet. i still need help