software

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

quot;Alanquot; gt; wrote in message
...
gt; How can I sum the total numbers contained in one column based on dates in
gt; another column?
gt; Example: I need the total of 5 units sold int the month of January 2006. I
gt; have the sale ammounts in one column and the closing dates in another.
gt; What forumla would I use for this?
gt; Thanks in advance for any help.
gt;
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,quot;Month_You_Needquot;,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,quot;Month_You_Needquot;,B:B),

where Month_You_Need will be a number of the month you need (w/out quot;quot;).--
proper
------------------------------------------------------------------------
proper's Profile: www.excelforum.com/member.php...oamp;userid=33166
View this thread: www.excelforum.com/showthread...hreadid=529896One mo
=SUMPRODUCT(--(text(b2:b50,quot;yyyymmquot;)=quot;200601quot;),A2:A50)
Alan wrote:
gt;
gt; How can I sum the total numbers contained in one column based on dates in
gt; another column?
gt; Example: I need the total of 5 units sold int the month of January 2006. I
gt; have the sale ammounts in one column and the closing dates in another.
gt; What forumla would I use for this?
gt; Thanks in advance for any help.

--

Dave Peterson