sheet formula

M

Mandy

Hi I have been trying to figure this out for a while now. I need some major
help...
I have created a spreadsheet for Sunday to Saturday which calculates total
hours worked on a job. Now I would like to have a summary of all sheets
(Sunday thru to Saturday) to calculate on a seperate sheet all the totals for
the week. I am confused just reading this back but cant think of another way
to word it. Basically on one file I have tabs at the bottom for every day of
the month and I would like to add another tab which gives me totals for the
full week from the other tabs. Can someone help? Thanks in advance
 
S

Sean Timmons

easiest way I can think to do this with just formulas is to use SUMIF()

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)+SUMIF(Sheet2!A:A,A2,Sheet2!B:B) etc.

Assuming your names are in A and values are in B. Adjust as needed.

Otherwise, probably lookign at some VB stuff...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shift Schedule Formula 1
Formula for adding a day to a particular date. 1
calc time 3
sort days of week 3
day of the week and date formula 2
page names in a workbook 2
Average of last 30 days 9
sorting multiple sheets with one button? 1

Top