OK. I think I have an idea now.
Appreciate your help.
--
Thanks for your help,
Walter


"Andy B" wrote:

> Well, the way it works is that each part of the SUMPRODUCT formula will
> return a 1 (if it's true) or a 0 (if it's false). SUMPRODUCT will then
> multiply these together to get the result. For more info, have a look here:
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>
> --
> Andy.
>
>
> "Walter" <Walter@discussions.microsoft.com> wrote in message
> news:67447DBE-5D84-41B6-AB22-12363E8CF4FD@microsoft.com...
> > Thanks Andy. I would have never thought of trying a function that is
> > supposed to multiply the cells but it works.
> > --
> > Thanks for your help,
> > Walter
> >
> >
> > "Andy B" wrote:
> >
> >> 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
> >>
> >>
> >>
>
>
>