Calculating Sheet 1 and Sheet 2

RustyNail

New Member
Joined
Jan 16, 2005
Messages
5
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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

RustyNail

New Member
Joined
Jan 16, 2005
Messages
5
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, :pray: thanks.
 

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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))
 

Forum statistics

Threads
1,148,525
Messages
5,747,206
Members
424,068
Latest member
Salim khamis

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top