One mo
=SUMPRODUCT(--(text(b2:b50,"yyyymm")="200601"),A2:A50)



Alan wrote:

How can I sum the total numbers contained in one column based on dates in
another column?
Example: I need the total of 5 units sold int the month of January 2006. I
have the sale ammounts in one column and the closing dates in another.
What forumla would I use for this?
Thanks in advance for any help.

--

Dave Peterson