Hoping somone can help, I feel like this should be so simple......
I have a column I want to average, there are 3 scores possible in the column:
100
0
N/A
The N/A is null so if this is selected it should be removed from the average, the " 0 " should be calculated in the average when selected.
Currently I have the N/A being counted as null, however, "0" is not being considered.
I want to be able to include the " 0 " in the average and keep the N/A as null when selected.
The current formula I am using (which appeared to be working Friday and no longer worked as of yesterday)
avg(If(01,02,03,04,05,06,07,8, '<>N/A' ))
Deadline has been missed due to this, so any help is GREATLY appreciated!!!
Thanks so much!
Michelle

