Average if acting differently on Mac 2008 vs Windows 2003

[TimLCooley]

I am having an issue where my formula for averageif is not working on Mac 2008. I am getting the #DIV/0! error

Sheet1

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Product[/TD]
[TD]Competitor[/TD]
[TD]Product[/TD]
[TD]Product[/TD]
[TD]Competitor[/TD]
[TD]Competitor[/TD]
[TD]Product[/TD]
[/TR]
[TR]
[TD]Titles[/TD]
[TD]8[/TD]
[TD]100[/TD]
[TD]5[/TD]
[TD]30[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]98[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

formula I am using:

SHEETB2 CELL =averageif(Sheet1A2:Sheet1A8,Sheet2A2,SheetB2:SheetB8)

SHEETB3 CELL =averageif(Sheet1A2:Sheet1A8,Sheet2A3,SheetB3:SheetB8)

Sheet2 (PC)
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Product[/TD]
[TD]Competitor[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD]34[/TD]
[TD]36[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Sheet2 (Mac)
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Product[/TD]
[TD]Competitor[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Title[/TD]
[TD]#DIV/0![/TD]
[TD]36[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am not sure why the MAC version has an issue averaging when there is a zero in the SUM. How should I fix it? I would prefer to remove zeros if averaging, if possible.

 

[TimLCooley]

The cell number shouls look like this
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Product[/TD]
[TD="width: 64"]Competitor[/TD]
[TD="width: 64"]Product[/TD]
[TD="width: 64"]Product[/TD]
[TD="width: 64"]Competitor[/TD]
[TD="width: 64"]Competitor[/TD]
[TD="width: 64"]Product[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]98
[/TD]
[/TR]
</tbody>[/TABLE]

I couldn't figure out how to edit the numbers