You're welcome, and appreciate the feed-back.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Funkydan" wrote in message
ps.com...
On 22 Aug, 01:56, "Ragdyer" wrote:
The best way I have seen this done is by creating an actual list of the
sheets, and then ... refer to this data list of sheet names in the
formula.

Since your sheets are in numerical order, you can easily create this list
by
simply dragging down to copy.
In an out-of the-way location, say Z1, enter:
CS1
Then click the fill handle and drag down to Z24.
This gives you the list of sheet names.
Make *sure* your sheet tabs match this list *exactly*.

Then, try this formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&Z1:Z24&"'!I10:I119" ),1,INDIRECT("'"&Z1:Z24&"'!F10:F119")))

BTW ... you can also assign a name to this range of sheet names, and use
that in the formula instead.

Select Z1 to Z24, and click in the name box, and type in an appropriate
short name, say,
list
Then hit <Enter

You formula can now look like this:

=SUMPRODUCT(SUMIF(INDIRECT("'"&list&"'!I10:I119"), 1,INDIRECT("'"&list&"'!F10:F119")))

Although it *is* safer to include the apostrophes in the sheet names -
"just
in case",
since your sheet names *do not* contain spaces, you could revise your
formula to this:

=SUMPRODUCT(SUMIF(INDIRECT(list&"!I10:I119"),1,IND IRECT(list&"!F10:F119")))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
[snip]

Thank You Very Much Managed To Do it :)