If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula help or suggestions??
I need to sum all amounts by month posted (ex:April 2010 and May 2010
separately). My columns look like this: Col A ColB Date Amt 4/13/10 $100.00 4/14/10 $ 50.00 5/2/10 $200.00 5/5/10 $8.00 Would love any help anyone can provide! Thanks for the time!! -- crazidazi3 |
#2
|
|||
|
|||
Formula help or suggestions??
=sumproduct((month(a2:a22)=4)*b2:b22)
=sumproduct((month(a2:a22)=5)*b2:b22) -- Don Guillett Microsoft MVP Excel SalesAid Software "crazidazi3" wrote in message ... I need to sum all amounts by month posted (ex:April 2010 and May 2010 separately). My columns look like this: Col A ColB Date Amt 4/13/10 $100.00 4/14/10 $ 50.00 5/2/10 $200.00 5/5/10 $8.00 Would love any help anyone can provide! Thanks for the time!! -- crazidazi3 |
#3
|
|||
|
|||
Formula help or suggestions??
I would recommend either using a PivotTable, and then grouping by month, or
you can use the formula: =SUMPRODUCT(--(TEXT(A2:A10,"mm")="04",B2:B10) For all data in month of April, or =SUMPRODUCT(--(TEXT(A2:A10,"mm")="042010",B2:B10) for all data in April, 2010 -- Best Regards, Luke M "crazidazi3" wrote in message ... I need to sum all amounts by month posted (ex:April 2010 and May 2010 separately). My columns look like this: Col A ColB Date Amt 4/13/10 $100.00 4/14/10 $ 50.00 5/2/10 $200.00 5/5/10 $8.00 Would love any help anyone can provide! Thanks for the time!! -- crazidazi3 |
Thread Tools | |
Display Modes | |
|
|