Totaling dollar amount by month

[pentatonic145]

In column B I have listed a bunch of dates like 1/2/2007, 5/10/2007, 10/15/2007 and so on. In column E I have the revenue that I made on that day. I need to have a formula that will total the revenue in column E for the month of January and the proceeding months up to Dec. Can anyone help?

Thank you much!

[davesexcel]

Here's a formula that should work for you
=SUMIF('Master Sheet'!B:B,"<="&A3,'Master Sheet'!E:E)-SUMIF('Master Sheet'!B:B,"<"&A2,'Master Sheet'!E:E)
Enter a date in A3 and A2 in one sheet
the formula sums the values between the two dates

Here's an example workbook

Click the calender control to get values

[stevekirk]

hi,

this may help,

put jan o8 in d1
put feb 08 in d2 etc

=SUMPRODUCT(--(MONTH($A$1:$A$31)=MONTH(D1)),--(YEAR($A$1:$A$31)=YEAR(d3)),$B$1:$B$31)

put this formular in d1 and copy down.

dave,
brill - how did you get the calenders in the spread sheet?

steve

[royUK]

Why not use a PivotTable?

[davesexcel]

hi,

this may help,

put jan o8 in d1
put feb 08 in d2 etc



put this formular in d1 and copy down.

dave,
brill - how did you get the calenders in the spread sheet?

steve

Hi Steve,
It's been a while since I made that workbook...
I just tried to replicate it,
Goes something like...
Insert,Object,Calendar Control
My excel has it as Calendar Control 11.0
Once inserted you should be in design mode, and then work with it like any other control