SUMIF or PRODUCTIF or Chart? I'm not sure which

[Gtrtim112]

I thought this would be a simple spreadsheet but it's turned out to be a little difficult for me. I don't know if I need a chart table or what. I'm hoping someone can assist me in what I need here. Basically, I'm looking for a weekly total and average based on what was entered on daily tabs. I've attached a copy for you to see. I think it's self explanatory

[Gtrtim112]

I just got to thinking about this one and wonder if some type of list would work? I remember making lists before and then using those lists to help total columns. I'm not sure if I could actually work up the formula, though, without some help.

[ChemistB]

Ideally, you want to keep your data all on one page. You can split it up later for display if you need to. Either add a column for day of week or put the tables directly below each other. Is this possible with your data?

If it's not, you will need a separate SUMIF for each sheet you are referencing. For example, Week Total!B5 will be
=SUMIF(Monday!$A$5:$A$27,$A5,Monday!$C$5:$C$27) + SUMIF(Monday!$A$5:$A$27,$A5,Monday!$D$5:$D$27)*2 +SUMIF(Tuesday!$A$5:$A$27,$A5,Tuesday!$C$5:$C$27) + SUMIF(Tuesday!$A$5:$A$27,$A5,Tuesday!$D$5:$D$27)*2 +SUMIF(Wednesday!$A$5:$A$27,$A5,Wednesday!$C$5:$C$27) + SUMIF(Wednesday!$A$5:$A$27,$A5,Wednesday!$D$5:$D$27)*2+SUMIF(Thursday!$A$5:$A$27,$A5,Thursday!$C$5:$C$27) + SUMIF(Thursday!$A$5:$A$27,$A5,Thursday!$D$5:$D$27)*2+SUMIF(Friday!$A$5:$A$27,$A5,Friday!$C$5:$C$27) + SUMIF(Friday!$A$5:$A$27,$A5,Friday!$D$5:$D$27)*2

[Gtrtim112]

Ideally, you want to keep your data all on one page. You can split it up later for display if you need to. Either add a column for day of week or put the tables directly below each other. Is this possible with your data?

If it's not, you will need a separate SUMIF for each sheet you are referencing. For example, Week Total!B5 will be
=SUMIF(Monday!$A$5:$A$27,$A5,Monday!$C$5:$C$27) + SUMIF(Monday!$A$5:$A$27,$A5,Monday!$D$5:$D$27)*2 +SUMIF(Tuesday!$A$5:$A$27,$A5,Tuesday!$C$5:$C$27) + SUMIF(Tuesday!$A$5:$A$27,$A5,Tuesday!$D$5:$D$27)*2 +SUMIF(Wednesday!$A$5:$A$27,$A5,Wednesday!$C$5:$C$27) + SUMIF(Wednesday!$A$5:$A$27,$A5,Wednesday!$D$5:$D$27)*2+SUMIF(Thursday!$A$5:$A$27,$A5,Thursday!$C$5:$C$27) + SUMIF(Thursday!$A$5:$A$27,$A5,Thursday!$D$5:$D$27)*2+SUMIF(Friday!$A$5:$A$27,$A5,Friday!$C$5:$C$27) + SUMIF(Friday!$A$5:$A$27,$A5,Friday!$D$5:$D$27)*2

The 2nd option worked perfectly. I had to tweak it just a bit but it gave me the kickstart I needed to accomplish the workbook... thanks so much! I appreciate it!