» Summing Corresponding Values in Multiple Columns
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
Problem: Range A2:G5 contains the scores of four games.
Each row includes the names and scores of the three players who took part in the game specified in column A.
We want to calculate the total number of points scored in all four games by each of the players listed in cells A8:A12.
Solution:
Use the SUMIF function as shown in the following formula:
=SUMIF($B$2:$F$5,A8,$C$2:$G$5)
Book Store:
Recommended Books:
- Microsoft Outlook 2002 for Dummies
- Accounting the Easy Way
- Microsoft Access Version 2002 Step by Step
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Financial Reporting and Analysis (2nd Edition)
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.
