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
>>
>>
>>