Sum uniques on multiple worksheets
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 |
All times are GMT +1. The time now is 10:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com