linking worksheets with drop downs
 

I am trying to link worksheets that have multiple drop downs and time (in
minutes and hours) that auto calculate. the goal is to be able to tally how
much time is spent per week in the codes we have listed in the drop downs.
Example: if I spend 1:45 on Monday in code -0641, on Tues 30 minutes, Wed
2:58 I would need those to tally into the final worksheet. I know how to link
sheets but for some reason this sheet will not link. Is it because of the
drop downs or the auto timing or both? or something else? please help!
Thanks!

linking worksheets with drop downs
 

the dropdowns aren't hurting anything. you can use the SUMIF function
to do this (if your weeks are separated) or SUMPRODUCT function (if
all your times for all your weeks are together in one big list). Tell
us what data is in what rows and columns and we can give you the
function.

linking worksheets with drop downs
 

each day has its own worksheet so there are 7 worksheets for each week
column 1 has start time
column 2 has end time
column 3 automatically calculates columns 1 & 2
column 4 is a general description
column 5 has our codes in a drop down
column 6 has our counties in a drop down
there are more columns with more drop downs but what i am looking for is to
calculate total time spent in a particular code at the end of the week
without having to sort and add day by day

" wrote:

the dropdowns aren't hurting anything. you can use the SUMIF function
to do this (if your weeks are separated) or SUMPRODUCT function (if
all your times for all your weeks are together in one big list). Tell
us what data is in what rows and columns and we can give you the
function.

linking worksheets with drop downs
 

Create a new worksheet for your summary.
Fill column 1 with your list of codes, starting in cell A2.
In column 2, enter the following formula and copy down for all rows
with codes in column 1:
=SUMIF(Sunday!E:E,A2,Sunday!D:D)+SUMIF(Monday!E:E, A2,Monday!D:D)
+SUMIF(Tuesday!E:E,A2,Tuesday!D:D)+SUMIF(Wednesday !E:E,A2,Wednesday!
D:D)+SUMIF(Thursday!E:E,A2,Thursday!D:D)+SUMIF(Fri day!E:E,A2,Friday!
D:D)+SUMIF(Saturday!E:E,A2,Saturday!D:D)

linking worksheets with drop downs
 

I'm getting #VALUE in column 2 as a result.

" wrote:

Create a new worksheet for your summary.
Fill column 1 with your list of codes, starting in cell A2.
In column 2, enter the following formula and copy down for all rows
with codes in column 1:
=SUMIF(Sunday!E:E,A2,Sunday!D:D)+SUMIF(Monday!E:E, A2,Monday!D:D)
+SUMIF(Tuesday!E:E,A2,Tuesday!D:D)+SUMIF(Wednesday !E:E,A2,Wednesday!
D:D)+SUMIF(Thursday!E:E,A2,Thursday!D:D)+SUMIF(Fri day!E:E,A2,Friday!
D:D)+SUMIF(Saturday!E:E,A2,Saturday!D:D)