Microsoft Office excel 2007 home & stude...

Hello, 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 ScoreJohn 23

Mike 76

Jason 28

John 99

Mike 21

Jason 18Worksheet #2

Name Total ScoreJohn 99

Mike 21

Jason 18Your help will be greatly appreciated!

Hi, If your example data is in cells A1 to B6 on worksheet "Sheet1"

and

the three names/scores on "Sheet2" are in cells A1 to B3

then enter this formula in cell C1 on Sheet2:

=SUMIF(Sheet1!$A$1:$A$6,A1,Sheet1!$B$1:$B$6)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:

=SUMIF(Sheet1!$A$1:$A$6,A1,Sheet1!$B$1:$B$6)+B1I 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

Regards

That worked great! Thank you very much!!!

Ask Your Question

Weekly Poll

Do you think Microsoft's new Surface Go will be a hit?

Discuss in The Lounge

Poll History