Count with filter applied

[Berna11]

Good evening
here I am another question
in the attached file I would need to count based on the filter applied
on the Data sheet column F in column AC are YES / NO
in the Test sheet starting from C20
I would like to count and sum all the Tes
Thanks as always
of your help

[Limor_OP]

Hi,
is there a connection between 'Dati' and 'Test' tab?
what does "progr" mean? is this info taken from the other tab?

How does filtering 'Dati' effects 'Test' tab?

[Bo_Ry]

Not sure about this, maybe try at C20

=IFERROR(CHOOSE(MATCH(INDEX(Dati!$AC$20:AC$38,SMALL(IF(SUBTOTAL(3,OFFSET(Dati!$AC$20,ROW(Dati!$AC$20:AC$38)-ROW(Dati!$AC$20),)),ROW(Dati!$AC$20:AC$38)-ROW(Dati!$AC$19)),ROWS(C$20:C20))),{"No","Yes"},),0,MAX(C$19:C19)+1),"")

confirm with Ctrl+Shift+Enter

[Berna11]

thanks for the replies
@belinda 200

there is no relationship between Data sheet and Test sheet
the prog is only a progressive numbering.
the expected result: you should count the times the word Yes is found in column AC Data sheet by filtering the sheet in column F for some criteria in the specific case the filter is on GOL


@bo_Ry
in the attached file it seems to work but, it was with little data entered, increasing the data does not work anymore and I do not understand why
see new attached file
thanks

[Berna11]

Sorry it was the final line reference
AC $ 38

Thanks solved