MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sum up amounts that are linked to a date?

Posted by Jeff on February 21, 2001 2:34 PM

I have two columns of information - one is Date the other is Amount. I want to find a formula that will give me the sum of all amounts that have the date of 2/14/01 (or any other date I specify). Is there any way to do thi? I do not want to simply filter the list, I need the answer to be in a specific cell.


Posted by Aladin Akyurek on February 21, 2001 2:50 PM


Why do you restart another thread on this problem? Did the suggestion that I made at


not work?