COUNT with multiple Criteria

[Busymanjohn]

Little conundrum .... maybe i ahve been staring at this for too long ,,,, sample file attached .... I need the results in cells H2:H5 to count the number of Names that appear in Col C that match the date in Col B ( example date in H1 ) and the Code type in Col D ,,,, results should be as per cells H2:H5.

 

[Hui]

Try Countifs()

 

[PaulF]

H2: =COUNTIFS($D$2:$D$29,$G2,$B$2:$B$29,H$1)
Drag it down...

 

[Busymanjohn]

Hi Hui, apologies ,,, my mistake ,, I should have said that I am looking to return how many unique Names are in Col C ,,,,, so H2 result should be 2, H3 should be 2, H4 should be 1 and H5 should be 0

 

[Busymanjohn]

Thanks for the reply Paul F ... I just posted an update to my request ,, I have tried COUNTIFS ... even a sumproduct with countif ,,,, it's the unique piece that is throwing me.

 

[PaulF]

Array Formula H2: =SUM(IF(($G2=$D$2:$D$29)*($B$2:$B$29=H$1), 1/COUNTIFS($D$2:$D$29, G2, $C$2:$C$29, $C$2:$C$29, $B$2:$B$29, H$1), 0))
CSE - Drag it down...

 

[Busymanjohn]

Hey Paul ,,,, Sorry for the late reply ,,,, been a busy day today ,,,, this works a treat, I wasn't too far away with a sumproduct and countif ,,,,, much appreciated, thanks again