This *May* be missing a comma. Untested.

=SUMPRODUCT(SUMIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!J:J"),"=HCSO")),--SUMPRODUCT(COUNTIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!G:G"),"=F"))
--
HTH,
Barb Reinhardt



"JimG" wrote:

I am trying to count the number of times the value "F" appears in column G,
if the value "HCSO" appears on the same row in column J. And I need it to
calculate across 31 worksheets. I tried this but it returns the total number
of times "F" appears. Any Ideas?

=SUMPRODUCT(SUMIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!J:J"),"=HCSO"))--SUMPRODUCT(COUNTIF(INDIRECT("'7-"&ROW(INDIRECT("1:31"))&"'!G:G"),"=F"))