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 |
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 |
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 |
All times are GMT +1. The time now is 01:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com