# Counting Table

#### CST

##### New Member
Hi All,

I was wondering if I could get help with the following, I want to make a table that counts up totals across 5 sheets.

The sheets will be Monday, Tuesday, Wednesday, Thursday and Friday and a Total Sheet,

On the weekdays in the A column there will be a list of Names and in Column B there will be a number (eg, 1,2,3,4.5,5).

For example "John" does 2 hours on Monday and 3 hours on Wednesday, I want this to add upto 5 on the total sheet, the problems im having is that the names wont be in the same row on each day, they can be different rows on each day.

Cany anyone help with this ?

### Excel Facts

Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

#### Domenic

##### MrExcel MVP
Assuming that D2 contains the name of interest, such as John, try..

=SUMPRODUCT(SUMIF(INDIRECT("'"&{"Monday","Tuesday","Wednesday","Thursday","Friday"}&"'!A2:A100"),D2,INDIRECT("'"&{"Monday","Tuesday","Wednesday","Thursday","Friday"}&"'!B2:B100")))

Alternatively, try the following formula...

=SUMPRODUCT(SUMIF(INDIRECT("'"&\$G\$2:\$G\$6&"'!A2:A100"),D2,INDIRECT("'"&\$G\$2:\$G\$6&"'!B2:B100")))

...where G2:G6 contains the sheet names (Monday, Tuesday, etc.).

Hope this helps!

Replies
0
Views
221
Replies
3
Views
437
Replies
2
Views
194
Replies
3
Views
389
Replies
4
Views
304

1,191,721
Messages
5,988,303
Members
440,148
Latest member
sandy123

### 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