F
Fin Fang Foom
Hi everyone,
I have tough one here. I would like a formula to Sum unique values
across multiple worksheets. If you notice both worksheets has the
same
data and thats fine because those are 2 different days of the week.
I would like to sum the Net hours in column B on both worksheets just
the unique values. The correct total should be 28.68. Here is a small
example of my layout and formula below.
=SUMPRODUCT(--(RIGHT(A3:A100,5)<>"Total"),--
(MATCH(C3:C100&D3
100,C3:C100&D3100,0)=ROW(INDEX(C3:C100,0))-
ROW(A3)+1),B3:B100)
Worksheet (1)
Clock Net STD Total
75 7.44 79.83 2.12
Total 7.44 2.12
14 3.2 86.66 0.14
14 2.3 49.40 1.23
14 1.4 30.07 0.07
Total 6.9 1.45
52 7.44 79.83 2.12
Total 7.44 2.12
Worksheet (2)
Clock Net STD Total
75 7.44 79.83 2.12
Total 7.44 2.12
14 3.2 86.66 0.14
14 2.3 49.40 1.23
14 1.4 30.07 0.07
Total 6.9 1.45
52 7.44 79.83 2.12
Total 7.44 2.12
I have tough one here. I would like a formula to Sum unique values
across multiple worksheets. If you notice both worksheets has the
same
data and thats fine because those are 2 different days of the week.
I would like to sum the Net hours in column B on both worksheets just
the unique values. The correct total should be 28.68. Here is a small
example of my layout and formula below.
=SUMPRODUCT(--(RIGHT(A3:A100,5)<>"Total"),--
(MATCH(C3:C100&D3
100,C3:C100&D3100,0)=ROW(INDEX(C3:C100,0))-ROW(A3)+1),B3:B100)
Worksheet (1)
Clock Net STD Total
75 7.44 79.83 2.12
Total 7.44 2.12
14 3.2 86.66 0.14
14 2.3 49.40 1.23
14 1.4 30.07 0.07
Total 6.9 1.45
52 7.44 79.83 2.12
Total 7.44 2.12
Worksheet (2)
Clock Net STD Total
75 7.44 79.83 2.12
Total 7.44 2.12
14 3.2 86.66 0.14
14 2.3 49.40 1.23
14 1.4 30.07 0.07
Total 6.9 1.45
52 7.44 79.83 2.12
Total 7.44 2.12