Dates & dollar amounts
Posted by bob on September 02, 2001 6:41 AM
A B
1/10/01 $100
2/02/01 $200
2/07/01 $400
column A has dates, column B has dollar amounts. I need a formular to add dollar amounts for Feb
Thanks
Bob
Posted by Aladin Akyurek on September 02, 2001 6:44 AM
=SUMPRODUCT((MONTH(A2:A4)=2)*(B2:B4))
Aladin
