Hope you can help me. i've been trying to write a formula to return a row sum based on 2 criteria but keep returning incorrect answers or #value.
i have a duplicate table on another worksheet which is editable and compared against my master table on another worksheet.
here is what i thought would work.
=SUMIFS(Table2[data area]:[data area]",table2[column1],[@cell],table2[column3],table1[@cell]
I've tried index match but still relatively new to that and did return various values but nothing that was close. I figure index match will work but not sure how to correct it.
As well as numbers my table does contain some text and blank cells.