View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
excel guru i''m not
 
Posts: n/a
Default sumproduct 2 columns based on criteria in 3rd column

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