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.

=SUMPRODUCT(--(MONTH(B2:B50)=1),--(YEAR(B2:B50)=2006),A2:A50)

for January

change 1 in the month part to a different month



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Alan" wrote in message
...
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.

If I understand correctly what you need, then use SUMIF function.

For example, if you have dates in column A and amounts in column B, the
formula will look like:

=sumif(A:A,"Month_You_Need",B:B)

Month_You_Need is the month for which you want to add the amounts. If
your dates are in a date format (not months or month numbers), you
would want to convert them into month numbers first. So, you would add
a new column, say C, and enter formula MONTH(Cell A) into it. Then,
your SUMIF function will look like this:

=sumif(C:C,"Month_You_Need",B:B),

where Month_You_Need will be a number of the month you need (w/out "").


--
proper
------------------------------------------------------------------------
proper's Profile: http://www.excelforum.com/member.php...o&userid=33166
View this thread: http://www.excelforum.com/showthread...hreadid=529896

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