# Calculating Sheet 1 and Sheet 2

#### RustyNail

##### New Member
What would be the formula for this.

Sheet 1 will have 30 names (all names different) starting at A2 through A31 (A1 will have PERSON wrote in it). Starting with b2,c2,d2, ect , 52 times(will a number in it) across the sheet (for 52 weeks of the year) totaling in the last col. Starting with b1 will have WEEK1, c1 WEEK2, ect 52 times across.

Sheet 2 will have GROUP 1 (written in a1) and 5 names under it (starting at a2,a3,a4,a5,a6). Then skip a line, GROUP2 (say in a8) and 5 more names (starting in a9,a10,a11,a12,a13). B1 will have total written in it for the for the whole page down.

There will be 6 GROUPS on sheet 2.

I need the persons total on sheet 1 (as I add to each week) to total on sheet 2 no matter where their name might be.

A persons name could be on sheet 2 more than once, but only once per GROUP. I need it to locate where the names are and total.

Thanks for any help.

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Welcome:

=vlookup(A2,Sheet1!A:CA,53,false) should do it.

Thanks, I'll try this. I'm new to the advanced excel formulas, but I'm learning. Alot of info on this site and won't be a stranger. If this works, ray: thanks.

If the totals are in coulmn BB on Sheet1, enter in Sheet2

=INDEX(Sheet1!\$BB\$2:\$BB31,MATCH(A2,Sheet1!\$A\$2:\$A\$31,0))

Replies
10
Views
308
Replies
1
Views
197
Replies
6
Views
334
Replies
5
Views
178
Replies
1
Views
254

1,221,006
Messages
6,157,344
Members
451,417
Latest member
Ilu

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back