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
|