Adding Values in Excel

Microsoft Office excel 2007 home & stude...
July 25, 2010 at 08:10:15
Specs: Windows 7

I am trying to add values related to individuals from one worksheet to another worksheet. Is there a way to add the scores from sheet No 1 on sheet number 2?

(Worksheet 1)
Name Score

John 23
Mike 76
Jason 28
John 99
Mike 21
Jason 18

Worksheet #2
Name Total Score

John 99
Mike 21
Jason 18

Your help will be greatly appreciated!

See More: Adding Values in Excel

Report •

July 25, 2010 at 09:05:50

If your example data is in cells A1 to B6 on worksheet "Sheet1"
the three names/scores on "Sheet2" are in cells A1 to B3
then enter this formula in cell C1 on Sheet2:

Drag the formula down a further two rows alongside the names/scores and this is what you get:

	A	B	C
1	John	99	122
2	Mike	21	97
3	Jason	18	46

If you wanted column C to include the scores on "Sheet2" then use this in C1:

I wasn't sure from your post if there were already scores on "Sheet2" as you showed, or if you just had a list of names and wanted the totals from "Sheet1". If so the first formula works, but start with it in cell B1


Report •

July 25, 2010 at 10:27:20
That worked great! Thank you very much!!!

Report •

Related Solutions

Ask Question