On Tue, 21 Aug 2007 05:36:03 -0700, Pete_UK wrote:

Try this:

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

Hope this helps.

Pete

At least in XL2003 SUMIF is not listed as a function that can be used in a 3D
reference, and your formula will return a VALUE error. I don't know about
2007, nor did the OP indicate which version of XL he is using.
--ron