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"))