Jun 07 2020 02:33 AM
I need a formula to combine all the numbers in a column if they're also in a row with specific text.
Jun 07 2020 05:14 AM
It was good of you to post your file, but you left some threads dangling in your question:
Jun 07 2020 09:47 AM
1. The numbers in the "points" column
2. See 1
3. If the number in the "points" column (for example - B2) is in the same row as one of the rankings (letter), I need to get it, and all of the number with the same ranking, and sum them up.
4. The rankings in the "level" column and the M or C in the "section" column.
Jun 07 2020 11:16 AM
Why PivotTable in Sheet1 doesn't work with you?
Jun 07 2020 11:21 AM
Because that isn't a formula. That's a number I have to update by hand.
Jun 07 2020 11:38 AM
If you prefer to avoid Refresh, that could be
or bit more compact
=SUM(SUMIFS(Courses[points],Courses[level],$D4,Courses[Section],{"M","C"}))