formula bar?

glad it works.

Cheers
JulieD

"zach f" wrote in message
...
I tried to paste it in the cell that did not work. I just pasted it in the
box up above (whatever its called) and it worked.

Thanks
Zach

"JulieD" wrote:

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