Do you want to SUM the A and B values for all non-blank C's ?
Gives us a little more info.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"excel guru i''m not" wrote in
message ...
Can someone help me to with this formula?

I have 3 columns. Two of them have dollar amounts and the third one a
date.
How to I add the 2 columns based on the date in the third column without
counting blank fields.

A 4,228.50
B 295.00
C January 12, 2005