I am looking for a bit of help. I am making a compliance chart to average the amount of “yes, no, and n/a” in said chart. This is a per customer or patient. I am creating an average percentage across the board on how many yes there are for that same task (about 6 to 8 task). Some of those tasks may be an N/A, the coding on the “Total” of that task produces nothing when an N/A is used.
I would then like to average the TOTAL percentages to include zero percent compliance but I want to exclude the cells that are blank.
Is there a code that I could use to make that happen?
Currently I am using =AVERAGEIF(RANGE, “>0”, RANGE), this
however excludes the zero percentages, i need the zeros included in the overall percentage (example, I have 100, 100, 0, 50, it gives me a 83.3% when it should be 62.5%), and as I said, exclude the blank ones. If I do just an AVERAGEA it gives an error because that is a code in that box.
