I have the following Excel macro for calculating the average for a range of cells:
I need to amend the code to exclude cells with a "0" value from the average.Please Login or Register to view this content.
So, if I have 2, 2, 0, 2 in my cells, the current code calculates the average as 1.5, whereas I need it to ignore the zero and calculate as 2.
I've been looking on the web for answers but am out of my depth. Would anyone please be able to help?
Bookmarks