Hi

Try using SUMPRODUCT()
==SUMPRODUCT((Brakes_Date<=Summary!$A9)*(Brakes_Date>Summary!$A8)*(Brakes_Credit_Column))
If you want to use SUMIF, you'll have to do it in two steps. You'll need to
total the values above the first date and then subtract the total of the
values above the second date.

--
Andy.


"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