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) )
OMG!!!!!!!!!!!!!!! THAT WORKED PERFECT. EVEN WHEN I DRUG IT DOWN TO NEXT CELL. YOU ARE A GENIOUS.... THANK YOU!!!!!!!!!Lorenzo
You're welcome. Glad to help
There's a Mark as response link at the bottom of each post you get here. It helps people who Search for existing solutions - Thanks in advance
There's a Mark as response link at the bottom of each post you get here. It helps people who Search for existing solutions - Thanks in advance