JE McGimpsey <jemcgimpsey@[EMAIL PROTECTED]
> wrote in
news:jemcgimpsey-F4586D.10580305052008@[EMAIL PROTECTED]
> In article <Xns9A956BBC82CDFmarcoNOSPAMloyolaedu@[EMAIL PROTECTED]
>,
> "David M. Marcovitz" <marcoNOSPAM@[EMAIL PROTECTED]
> wrote:
>
>> As I said, this works perfectly in Windows Excel, but it seems to be
>> a bug in Mac.
>
> The same workbook calculates different results in WinXL and MacXL?
>
> I've never seen this where there are no errors in the data itself
> (under some cir***stances, SUMPRODUCT() returns somewhat different
> results in MacXL and WinXL97 than does WinXL00/02/03/07 when there are
> XL errors in the data).
>
> By any chance are any of the amounts entered as Text?
>
The data that SUMIF is working with is all based on calculations (one
column comes from MONTH, and the other comes from a slightly complicated
IF statement to determine if anything belongs in that slot). I have only
tried this with Excel 2004 and Excel 2003 (running on a MacIntel), as
well as a calculator. When I opened the SS in 2003, the results matched
my calculator. When I opened the SS in 2004, they didn't. I would prefer
to keep this in 2004 as I rarely open Windows on that machine
Now, you ask if any of the amounts are text. Yes and no. Some of the
amounts are blank, and the blank is based on an IF formula. I would
assume that SUMIF would just ignore the blanks or treat them as 0.
--David
--
David M. Marcovitz
Microsoft PowerPoint MVP
Author of _Powerful PowerPoint for Educators_
http://www.PowerfulPowerPoint.com/
|
