Hi everyone,
I have tough one here. I would like a formula to Sum uniques values
across multiple worksheets. If you notice both worksheets has the
same
data and thats fine because thoses 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:D100,C3:C100&D3:D100,0)=ROW(INDE X(C3:C100,0))-
ROW(A3)+1),B3:B100)

Worksheet (1)


Clock Net STD Total
75 7.44 79.83 2.12
75 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
14 Total 6.9 1.45

52 7.44 79.83 2.12
52 Total 7.44 2.12




Worksheet (2)


Clock Net STD Total
75 7.44 79.83 2.12
75 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
14 Total 6.9 1.45

52 7.44 79.83 2.12
52 Total 7.44 2.12