"countifs" across multiple sheets

[SOS911]

This works for the sheet it is on

=COUNTIFS(H:H,"PFIZER",I:I,">=1/1/20")

need a total count from all my sheets.

I can get it to count one value but not if i need it to look at two.

sheets are listed in column A. A1:A52

 

[Eric W]

Welcome to the MrExcel forum!

Try:

Book1 (version 1).xlsb
	A	B
1	Sheet1	4
2	Sheet2
3	Sheet3
4
Sheet11

Cell Formulas
Range	Formula
B1	B1	=SUMPRODUCT(COUNTIFS(INDIRECT("'"&A1:A3&"'!H:H"),"Pfizer",INDIRECT("'"&A1:A3&"'!I:I"),">=1/1/20"))