CountIf Index Match Array not sure ?

[Prospidnick]

Hi I wish to match a date in a column G from my search criteria in cell I2, return the row value from Column H and count the matching occurrences.

I have a screenshot of my desired results which are in Columns J & K

Any help please would be appreciated

Many thanks

Pros

[Phlegon_of_Tralles]

Can you attached a worksheet and not just an image?

Also, is this what you are looking for:

=INDEX(H:H,match(I2,G:G,0))

[Phlegon_of_Tralles]

Actually it doesn't look like that's what you are looking for - maybe a sum product or a SUMIF?

[Phuocam]

Try in J2:

=INDEX($H$2:$H$20,MATCH(1,INDEX(($G$2:$G$20=$I$2)*(COUNTIF($J$1:J1,$H$2:$H$20)=0),0),0))

In K2:

=COUNTIFS($G$2:$G$20,$I$2,$H$2:$H$20,J2)

[Prospidnick]

Try in J2:

=INDEX($H$2:$H$20,MATCH(1,INDEX(($G$2:$G$20=$I$2)*(COUNTIF($J$1:J1,$H$2:$H$20)=0),0),0))

In K2:

=COUNTIFS($G$2:$G$20,$I$2,$H$2:$H$20,J2)

Absolutely Spot On, thanks sooo much for your quick and accurate response.

[Prospidnick]

Actually it doesn't look like that's what you are looking for - maybe a sum product or a SUMIF?

Hi Phlegon, thanks for the quick response, apologies for the confusion as to the formula, that was me testing, Phuocam solution has worked perfectly, thanks again.