Excel Sum of data in date range ?

By mattbeardall ·
I attempting to make a check register in MS Excel, but I want it to have
the ability to tell me how much money was spent in each month. For

Column A----------Column B--------------Column E
Date--------------Debit Amount----------Monthly Total
01/04/08----------$2.00-----------------Jan. 2008 = $11.00
01/31/08----------$9.00-----------------Feb. 2008 = $ 4.00
02/07/08----------$4.00-----------------Mar. 2008 = $ 0.00
04/08/08----------$8.00-----------------Apr. 2008 = $ 8.00
And so on...

All the data is in the same list, sorted by the above columns. Column
E is what I would like it to do (Jan-Dec) Jan needs to be able to pick
out all/only debits made in Jan., Feb. needs to pick out only those
made in Feb. and so forth.

How would could I write a formula or work the data so that this is

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums