Formula to count values with unique values and different criteria

[Graham C1600]

[TABLE="width: 500"]
<tbody>[TR]
[TD]a
[/TD]
[TD]b
[/TD]
[TD]c
[/TD]
[TD]d
[/TD]
[TD]e
[/TD]
[TD]f
[/TD]
[/TR]
[TR]
[TD]123
[/TD]
[TD]John
[/TD]
[TD]Smith
[/TD]
[TD]01/01/2019
[/TD]
[TD]5/04/2019
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]12345
[/TD]
[TD]Simon
[/TD]
[TD]Taylor
[/TD]
[TD]01/01/019
[/TD]
[TD]03/12/2018
[/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]43433
[/TD]
[TD]June
[/TD]
[TD]Brown
[/TD]
[TD]01/01/2019
[/TD]
[TD]03/01/2019
[/TD]
[TD]Yes
[/TD]
[/TR]
[TR]
[TD]234
[/TD]
[TD]Paul
[/TD]
[TD]Baker
[/TD]
[TD]01/01/2019
[/TD]
[TD][/TD]
[TD]No
[/TD]
[/TR]
[TR]
[TD]12345
[/TD]
[TD]Rij
[/TD]
[TD]Veech
[/TD]
[TD]01/01/2019
[/TD]
[TD]03/03/019
[/TD]
[TD]No
[/TD]
[/TR]
</tbody>[/TABLE]

In Cell H1 I need a formula look down column F and ensure it looks for "No", then to look down column E3:E7 and where there is data, count column A3:A7. But I only need unique values. So in this case it would be 2.
In Cell H2 I need a formula look down column F and ensure is looks for "No", then to look down column E3:E7 and where there are blanks, count column A3:A7. But I only need unique values. So in this case it would be 1.
In Cell H3 I need to count all the cells in E3:E7 that contain data and column F also contains "No". This would be 3.
In Cell H4 I need to count all the cells in E3:E7 that are blank and column F also contains "No". This would be 1

Hope this makes sense.

Thanks in advance.

 

[Marcelo Branco]

Try

Array formula
=SUM(IF(FREQUENCY(IF(B2:B20<>"",IF(C2:C20="NO",MATCH(A2:A20,A2:A20,0))),ROW(A2:A20)-ROW(A2)+1),1))
confirmed with Ctrl+Shift+Enter, not just Enter

M.

 

[Graham C1600]

Try

Array formula
=SUM(IF(FREQUENCY(IF(B2:B20<>"",IF(C2:C20="NO",MATCH(A2:A20,A2:A20,0))),ROW(A2:A20)-ROW(A2)+1),1))
confirmed with Ctrl+Shift+Enter, not just Enter

M.

Works a treat. Thanks for the help.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.