On Sunday, August 16, 2009 at 1:32:39 PM UTC-5, Domenic wrote:
In which format are your sheets named? Are they in this format
'Entity1' (no space between Entity and 1)? Or are they in this format
'Entity 1' (a space between Entity and 1)? If the latter, try

=SUMPRODUCT(COUNTIF(INDIRECT("'Entity
"&ROW(INDIRECT("1:1000"))&"'!C6"),"Yes"))

If the former, replace

"'Entity "

with

"'Entity"

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

I have the same scenario as above, but my sheets are just numbered 1-250. Trying to figure out how to edit the formula.

Thanks!