Try this:

=SUMIF(CS1:CS24!I10:I119,"=1",CS1:CS24!F10:F119)

Hope this helps.

Pete

On Aug 21, 1:19 pm, Funkydan wrote:
Hi All,

If There away can simplify a Sumif Function?

I have the following formula

=SUMIF('CS1'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS2'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS3'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS4'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS5'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS6'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS7'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS8'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS9'!I10:I119,"=1",'CS1'!F10:F119)
+SUMIF('CS10'!I10:I119,"=1",'CS1'!F10:F119)
and So On up to Cost Sheet CS24 and Then theres 24 IF's

is there a way i can Make its work like this?

=SUMIF('CS1-CS24'!IAll,"=1",'CS1-CS24'!FAll)

All CS1- CS24 Sheets are Identical Apart from One Sheet

Can this be done?