Alexandervanzijl
New Member
- Joined
- Mar 3, 2011
- Messages
- 1
Hello,
Im having a problem
I use the function:
=SUMIFS('WK (1)'!J:J;'WK (1)'!A:A; "COLEUS GIANT";'WK (1)'!B:B; "Oppotten")
This gives me a value I need to calculate the amout of hours ( in the 'j' column) people are 'oppotten'(planting plants in dutch's ) Coleus Giants (name of a plant).
This works great but I need it to work over multiple worksheets.
For some strange reason I just can't get it to work.
I look on multiple forums and they say I need something like:
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A2:A10"),D2,INDIRECT("'"&SheetList&"'!B2:B10")))
The reason why this cannot work is because I dont have all the worksheets yet. (each worksheet is an worklist for each emplyee per week)
The worksheets name is WK (1) and add 1 so its something like , wk(2), wk (3)....
Should I try a different way or can somebody help me.
Thank you in advance
Alex
Im having a problem
I use the function:
=SUMIFS('WK (1)'!J:J;'WK (1)'!A:A; "COLEUS GIANT";'WK (1)'!B:B; "Oppotten")
This gives me a value I need to calculate the amout of hours ( in the 'j' column) people are 'oppotten'(planting plants in dutch's ) Coleus Giants (name of a plant).
This works great but I need it to work over multiple worksheets.
For some strange reason I just can't get it to work.
I look on multiple forums and they say I need something like:
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A2:A10"),D2,INDIRECT("'"&SheetList&"'!B2:B10")))
The reason why this cannot work is because I dont have all the worksheets yet. (each worksheet is an worklist for each emplyee per week)
The worksheets name is WK (1) and add 1 so its something like , wk(2), wk (3)....
Should I try a different way or can somebody help me.
Thank you in advance
Alex
