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.

Thanks!!!


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

Jeff:

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

10617.html

not work?

Aladin