A formula stopped working

H

Howard Brazee

I retired at the end of the year and now use Office 2011 for the Mac
instead of my work office 2007? for Windows. (I upgraded my Office
for Mac to be able to use macros a few months ago).

My golf season started, and I pulled out a macro-enabled spread sheet
that used to work fine on Windows.

I have a column that I use to determine my average score on par-3
holes for a round. Here is AD96


=IF(ISNUMBER(Score!U96),SUMIF(Par!C96:U96,"=3",Score!C96:U96)/COUNTIF(Par!C96:U96,"=3"),"")

Looking at my other pages, I see Score!C96:W96 displays:
6 5 6 4 5 4 5 4 4 43 6 10 5 6 3 5 6 6 5 52 95

I see Par!C96:W96 displays:
4 4 5 3 5 3 4 4 4 36 4 4 3 5 3 5 4 4 4 36 72

I used to get a calculated score of (4+4+5+3) / 4

Instead of seeing a 4.00 in AD96, it displays 3.00

Every AD shows 3.00 (AE shows 4.00 & AF show 5.00 looking for par 4
and par 5 scores).

Any idea what I should look for that changed since I was running this
program on Excel for Windows?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top