Thanks Julie for your help. It worked although I'm not quite sure why since
its supposed to multiply the cells. But there's a lot I don't understand.
Many thanks again.
--
Thanks for your help,
Walter


"JulieD" wrote:

Hi Walter

a SUMIF can only take one criteria, try
=SUMPRODUCT(--(Brakes_Date<=Summary!$A9),--(Brakes_DateSummary!$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" wrote in message
...
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,Br akes_DateSummary!$A8),Brakes_Credit_Column)
--
Thanks for your help,
Walter