Hi Walter

a SUMIF can only take one criteria, try
=SUMPRODUCT(--(Brakes_Date<=Summary!$A9),--(Brakes_Date>Summary!$A8),Brakes_Credit_Column)

ensuring that all your ranges have the same dimensions.
check out
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
for more details on this function

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Walter" <Walter@discussions.microsoft.com> wrote in message
news:0ECDFBCC-54AC-41B3-8F0E-C332A7BEE574@microsoft.com...
>I am trying to sum daily entries on one worksheet to a weekly total on a
> summary worksheet. I have named the following ranges:
> summary date column = Summary_Date
> brakes date column = Brakes_Date
> brakes debit column = Brakes_Debit_Column
> brakes credit column = Brakes_Credit_Column
>
> Here is the formula I have but it is returning 0.
> =SUMIF(Brakes_Date,AND(Brakes_Date<=Summary!$A9,Brakes_Date>Summary!$A8),Brakes_Credit_Column)
> --
> Thanks for your help,
> Walter