Column A contains GRADES, A-L. Column B contains NAMES. Column C contains NUMBERS.
I need to formulas that add all the numbers that are graded A, then one for B, and so on.
I know I could sort and sum it but was hoping to find a formula.
How do I add a column in EXCEL based on the values in a different column?
You need an "Sumif" statement.
It's on the Excel help pages if you hit F1.
=sumIf(A1..A2000=A2002,C1..C2000)
Where you put the grade A in cell A2002
calling cards
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment