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