MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Steve on December 20, 2001 5:12 AM

I have one column with dates (A1:A10) and another with dollars (B1:B10) and I would like to sum all of the numbers in B1:B10 where the date in C1 is greater than each date in cells A1:A10.

Posted by Ian Mac on December 20, 2001 5:19 AM

=SUMPRODUCT((A1:A10>C1)*(B1:B10)) (NT)

Posted by IML on December 20, 2001 6:28 AM

I think
would be a little cleaner.

Good luck

Posted by Aladin Akyurek on December 20, 2001 6:29 AM

Steve --




Posted by Ian Mac on December 20, 2001 7:14 AM



Aladin answer is cleaner as IML said and also correct as IML and my own answer will give you opposite of what you want, i.e. everything that is greater than the date NOT that the date is greater than.

Ian Mac