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.
5 Replies
It was good of you to post your file, but you left some threads dangling in your question:
- What numbers,
- what column(s),
- what row(s)
- what specific text?
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.
Why PivotTable in Sheet1 doesn't work with you?
