Hi everyone,
I'm struggling with a big spreadsheet I'm working on, and I can't seem to find a way to get rid of the #div/o error. I find it looks messy and confusing, and I just want to replace it with something like "N/A". While I've found some other threads that have asked this question, my formula is a little more confusing so I'm not quite sure how to alter it to make it work.
Here is the formula I'm using: =SUM(E5:E124)/COUNTIF(E5:E124,">0")
Can anyone tell me what I need to change this to to have it show "N/A" instead of the error message?
Thanks!
I'm struggling with a big spreadsheet I'm working on, and I can't seem to find a way to get rid of the #div/o error. I find it looks messy and confusing, and I just want to replace it with something like "N/A". While I've found some other threads that have asked this question, my formula is a little more confusing so I'm not quite sure how to alter it to make it work.
Here is the formula I'm using: =SUM(E5:E124)/COUNTIF(E5:E124,">0")
Can anyone tell me what I need to change this to to have it show "N/A" instead of the error message?
Thanks!