CharlesH
04-11-2011, 04:46 PM
HI,
I'm trying to help a friend who switched to the Mac. He has a file that worked in "Windows". However, he now uses the same Excel file with Mac 2011 Excel. I looked at his file in both Windows and Mac and there is a difference.
The following formula gives the correct result in Windows, but it does not give the desired result on the Mac.
Here's the formula.
IF(ISNUMBER(Score!U96),SUMIF(Par!C96:U96,"=3",Score!C96:U96)/COUNTIF(Par!C96:U96,"=3"),"")
The result he is looking for is in column "AD98" ( this formula in in column AD)and the result should be a "4" (this value in in the widows side) but for the Mac it shows a "3". Is there a compatibility issue with formulas between the Mac and Windows.
All of the formats for both the Windows and Mac are the same.
I'm trying to help a friend who switched to the Mac. He has a file that worked in "Windows". However, he now uses the same Excel file with Mac 2011 Excel. I looked at his file in both Windows and Mac and there is a difference.
The following formula gives the correct result in Windows, but it does not give the desired result on the Mac.
Here's the formula.
IF(ISNUMBER(Score!U96),SUMIF(Par!C96:U96,"=3",Score!C96:U96)/COUNTIF(Par!C96:U96,"=3"),"")
The result he is looking for is in column "AD98" ( this formula in in column AD)and the result should be a "4" (this value in in the widows side) but for the Mac it shows a "3". Is there a compatibility issue with formulas between the Mac and Windows.
All of the formats for both the Windows and Mac are the same.