Forum Discussion
Formula assistance needed
I need a formula to combine all the numbers in a column if they're also in a row with specific text.
Why PivotTable in Sheet1 doesn't work with you?
Because that isn't a formula. That's a number I have to update by hand.
If you prefer to avoid Refresh, that could be
or bit more compact
=SUM(SUMIFS(Courses[points],Courses[level],$D4,Courses[Section],{"M","C"}))