|Is this how your data is set up:|
A B C D E F G
1) Start End Rate Total Jan Feb Mar
2) 1/1/2013 4/15/2013 $80 $34,880 $14,720 $12,800 $7,360
You want each Month's total to be displayed separately?
You will need a formula for each month.
The simplist way I can think of is on Row 1 enter the Date
but only display the Month.
So in the above example
Cell E1 would contain 01/01/2013
Cell F1 would contain 02/01/2013
You can then Custom Format the cells to display only the Month
with a Custom Format of:
MMM for the short version IE: Jan
MMMM for the complete month IE: January
Then in Cell E2 enter the formula:
You can then drag the formula right
as many columns as needed.
That should give you what your looking for.