Sum : Filter with Unique Condition

[chandrashekar]

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

 

[Fluff]

How about

=SUM(FILTER(Sheet1!F2:F20,(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))

 

[chandrashekar]

How about

=SUM(FILTER(Sheet1!F2:F20,(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))

Hello,

Thanks it is working.

Regards,
Chandrashekar B

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peter_SSs]

Wondering what did "unique" in you thread heading have to do with this question? Wasn't this related to your previous question about unique count with similar data?