Hi,

first time poster

i have been using the the formula:

=SUM(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!C1:C1000"),"="&H3))

what im trying to work out is how to use this formula if the worksheet is called something different?

my worksheets are named after the date 18-10-11.

Any idea's would be appreciated.