chandrashekar
Well-known Member
- Joined
- Jul 15, 2005
- Messages
- 517
- Office Version
- 365
- Platform
- Windows
Hello,
How to get sum of Hours on below attached sample data.
Sample data: Sample Data
Formula used to get unique count: =IFERROR(ROWS(UNIQUE(FILTER(Sheet1!B2:B20,(Sheet1!A2:A20<>"HD")*(Sheet1!C2:C20=1)*(Sheet1!E2:E20="CH")*(IFERROR(Sheet1!D2:D20="First",0)+IFERROR(Sheet1!D2:D20="Second",0))))),0)
Regards,
Chandrashekar B
How to get sum of Hours on below attached sample data.
Sample data: Sample Data
Formula used to get unique count: =IFERROR(ROWS(UNIQUE(FILTER(Sheet1!B2:B20,(Sheet1!A2:A20<>"HD")*(Sheet1!C2:C20=1)*(Sheet1!E2:E20="CH")*(IFERROR(Sheet1!D2:D20="First",0)+IFERROR(Sheet1!D2:D20="Second",0))))),0)
Regards,
Chandrashekar B