Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks

Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"=" &
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks

Well I am not sure I have keyed what I think is the same thing you have below
and I am getting an error message at the AC1211 (The 1st AC1211)...

"Frank Kabel" wrote:

Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"=" &
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks

Hi Zach

if you're "trying to do this on a seperate worksheet from all of [your]
data." you need to include the sheet names in the ranges e.g.
=SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,1,1),Sheet1!AC2:AC1211)-SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,2,1),Sheet1!AC2:AC1211)

Cheers
JulieD

"zach f" wrote in message
...
Well I am not sure I have keyed what I think is the same thing you have
below
and I am getting an error message at the AC1211 (The 1st AC1211)...

"Frank Kabel" wrote:

Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"=" &
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an
invoice by
month. I have things on this invoice that go back to January 2004. My
dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am
trying to
do this on a seperate worksheet from all of my data.

Thanks

Correct. I will eventually put it on a seperate spreadsheet but until I get
the formula to work i am putting it on the same worksheet that all my data is
on.

Zach

"JulieD" wrote:

Hi Zach

if you're "trying to do this on a seperate worksheet from all of [your]
data." you need to include the sheet names in the ranges e.g.
=SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,1,1),Sheet1!AC2:AC1211)-SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,2,1),Sheet1!AC2:AC1211)

Cheers
JulieD

"zach f" wrote in message
...
Well I am not sure I have keyed what I think is the same thing you have
below
and I am getting an error message at the AC1211 (The 1st AC1211)...

"Frank Kabel" wrote:

Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"=" &
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an
invoice by
month. I have things on this invoice that go back to January 2004. My
dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am
trying to
do this on a seperate worksheet from all of my data.

Thanks

Hi Zach

could you copy & paste your formula into a post as there appears (to me) to
be nothing wrong with the formula Frank has give you. Additionally, what
version of excel are you using - if it's 2002 or 2003 there's a handy tool
under tools / formula auditing / evaluate formula
which you can use to step through a formula to see where it goes wrong ..
maybe that will give you a clue.

Cheers
JulieD

"zach f" wrote in message
...
Correct. I will eventually put it on a seperate spreadsheet but until I
get
the formula to work i am putting it on the same worksheet that all my data
is
on.

Zach

"JulieD" wrote:

Hi Zach

if you're "trying to do this on a seperate worksheet from all of [your]
data." you need to include the sheet names in the ranges e.g.
=SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,1,1),Sheet1!AC2:AC1211)-SUMIF(Sheet1!Y2:Y1211,"=" &
DATE(2004,2,1),Sheet1!AC2:AC1211)

Cheers
JulieD

"zach f" wrote in message
...
Well I am not sure I have keyed what I think is the same thing you have
below
and I am getting an error message at the AC1211 (The 1st AC1211)...

"Frank Kabel" wrote:

Hi
do you mean
=SUMIF(Y2:Y1211,"=" & DATE(2004,1,1),AC2:AC1211)-SUMIF(Y2:Y1211,"="
&
DATE(2004,2,1),AC2:AC1211)

For getting the January values

"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an
invoice by
month. I have things on this invoice that go back to January 2004.
My
dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am
trying to
do this on a seperate worksheet from all of my data.

Thanks

Hi,
You might consider using a pivot table to summarize your data, and then
group it by month. For help in getting started setting up your pivot tables
consider the following sites:
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/xlPivot02.html
http://www.contextures.com/xlPivot01.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm


"zach f" wrote:

Hello, I am trying to sum the total $ amount we are paying on an invoice by
month. I have things on this invoice that go back to January 2004. My dates
are in cells Y2:Y1211 and my totals are in cells AC2:AC1211. I am trying to
do this on a seperate worksheet from all of my data.

Thanks