Monday, May 24, 2010

How do I add a column in EXCEL based on the values in a different column?

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

No comments:

Post a Comment