Multiple Indirect with Countif

=IF(H7<>"",COUNTIFS('[Ebay JAN-DEC 2022.xlsm]JULY-2022'!$T$31:$U$2018,"=0",'[Ebay JAN-DEC 2022.xlsm]JULY-2022'!$C$31:$D$2018,LEFT(H7,13)),"")

I am using above formula Howeve I need to change month name every month, to find stock change.
Formula should change for a month name If I change A1.

A1=JULY
H7 is Unique identifier Numbers for the search.

Hi there.

What is "Unique EAN"?

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.