I have daily data...i want to turn into monthly by adding

**starstill** · 01-29-2010, 08:30 PM

Hello,

I have the following two columns:

Date | Sales

01-05-2009 | $50000
. .
. .
. .
. .
. .

I have this daily...and i want to combine the sales amount to monthly totals.

How do I do that?

thanks

**Palmetto** · 01-29-2010, 09:01 PM

There are multiple ways to achieve this.

1. Pivot Table
2. Sub-Totals Function
3. Sumif function

Basic Excel Training

**starstill** · 01-30-2010, 06:16 PM

Originally Posted by Palmetto

There are multiple ways to achieve this.

1. Pivot Table
2. Sub-Totals Function
3. Sumif function

Basic Excel Training

I'm trying to use the SUMIF function shown here...http://www.dailydoseofexcel.com/arch...een-two-dates/

=SUMIF(A1:A9,"<="&DATE(2004,4,2),B1:B9)-SUMIF(A1:A9,"<"&DATE(2004,3,29),B1:B9)

Except it's not working.

My dates are like this:

03-18-2009
03-19-2009
.
.
.

That's what show in the bar when i click on it also. How do i convert them so i can use that formula? Or make a new formula for me which would be amazing.