Forum Discussion
Excell
We have budget items with short descriptions, a dollar amount per description and then prioritized by the letters A, B and C. We have 6 different categories with the budget items that are prioritize...
Let's say the descriptions are in A2:A500, the amounts in B2:B500 and the A/B/C classifications in C2:C500.
In (for example) F1, enter Classification, and in G1, enter Total.
In F2, F3 and F4, enter A, B and C, respectively.
In G2, enter the formula
=SUMIF($C$2:$C$500,F2,$B$2:$B$500)
Fill or copy down from G2 to G3 and G4.