MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula Required.


Posted by Trish Proulx on November 14, 2001 3:38 PM

I require a formula that will enable me to add the number of brochures sent out between two dates i.e. January 1, 2002 and January 31, 2002.

Column A = Date
Column B = # of brochures sent

Sample
January 05, 2002 53
January 12, 2002 20
January 20, 2002 5
January 25, 2002 21
January 31, 2002 1
February 5, 2002 5
February 11, 2002 10

The total of brochures sent out for January is 100.

Thank you for any help you can give.

Trish Proulx


Posted by Aladin Akyurek on November 14, 2001 3:48 PM

=SUMPRODUCT((TEXT(A2:A8,"mmmm")="January")*(B2:B8))

You can also have January in a cell, say in D2 and use D2 instead of "January" in the above formula.

Aladin

===========

Posted by Trish Proulx on November 14, 2001 4:27 PM

Re: Formula Required Thanks

I had to add a column for the month i.e. January and then tried the formula and it worked. Thank you very much for your help. This has to be one of the greatest help sites I have used.

Trish Proulx.