Excel 2004.
Mac OS X 10.4
I am getting inconsistent and incorrect results using SUMIF.
I have a spreadsheet with a column of dates. I use the MONTH function to
extract the month to a new column. I then use other formulas to extract
a dollar figure to a new column so I end up with a column of months with
dollar figures next to it. I then want to add up the dollar amount for
each month. There are a couple of hundred rows so it looks something
like this:
1 $25.36
2 $13.28
1 $12.22
1 $17.65
2 $10.97
3 $100.00
4 $12.52
2 $7.44
4 $1.33
3 $9.22
etc.
This should be easy for SUMIF, and it works perfectly in Windows, but I
am not getting correct results on the Mac. I have created a little table
for the months and the totals for each month, so the formula looks
something like this:
=SUMIF(S$4:S$1000,U2,T$4:T$1000)
This should look at the values in column S, check to see if they are
equal to the value in cell U2 (that's my little table with the number of
the month, so as I fill down, that becomes 1 then 2 then 3 ... then 12
for each month). Right now, my March numbers show $3 even though there
are a few hundred dollars for March in column T, and my April number is
short about $25 (which is even more frustrating because it looks like a
reasonable number but isn't).
As I said, this works perfectly in Windows Excel, but it seems to be a
bug in Mac. I'm sure there are lots of other ways to do this, but this
way should work. Any thoughts as to why it doesn't?
--David
--
David M. Marcovitz
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
|
