Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique values based on multiple criteria | Excel Discussion (Misc queries) | |||
Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
Sum multiple Unique Values in col | Excel Worksheet Functions | |||
How to sum values in multiple worksheets | Excel Worksheet Functions |