This will sum rng D if dates in rng A are as desired.
=SUMIF(rngaA,DATE(2007,3,5),rngdD)

--
Don Guillett
SalesAid Software

wrote in message
oups.com...
When I perform this function, after (2007,3,5) the cell output is
"0".
I need for the information that is displayed on (2007,3,5) to be
permanent and not
change to "0" when (2007,3,5) has passed.
=SUMIF(A1,"="&DATE(2007,3,5),Summary!F14)

I can't use this formula because I am displaying accumulating data
every week and it will be overwritten with the new data and not
preserve the old information.
=SUMIF(A1,"="&DATE(2007,3,5),Summary!F14)

Thanks for any suggestions you can give me!