Count on multiple sheets with condition

[Berna11]

Good morning,
i would need your help to modify a formula that counts on multiple sheets with one condition.
In the Total sheet in column B I have a formula that counts how many times the value of column A is present in column B of sheets E3: E4

Now, my need is that, up to row 7 of the various sheets, the furnace is fine but, from row 8 downwards it must count only if an X is found in column D

I hope it is clear
Thank you

[Bo_Ry]

Please try at B3
=SUMPRODUCT(COUNTIFS(INDIRECT("'"&$E$3:$E$4&"'!B3:B22"),A3,INDIRECT("'"&$E$3:$E$4&"'!D3:D22"),"X"))

[Berna11]

Hi Bo
Thanks for the reply
perhaps I have not made myself clear
For cells colored in yellow it is ok

but the others above where you see the 2 must come out the 2
Example counting how many times A is found in 2s
sheets twice even if there is no X
I hope it is clear
Thank you

[Bo_Ry]

Maybe try

=SUMPRODUCT(COUNTIFS(INDIRECT("'"&$E$3:$E$4&"'!B3:B7"),A3))+SUMPRODUCT(COUNTIFS(INDIRECT("'"&$E$3:$E$4&"'!B8:B22"),A3,INDIRECT("'"&$E$3:$E$4&"'!D8:D22"),"X"))

[Berna11]

Hello!
now it's perfect
thanks as always