I have an excel question in case anyone can help me. I have a field that calculates the difference between one cell and another. This goes on for a number of cells, let’s say A1:A10. I want to be able to calculate the average between each of these cells but to exclude any zero values, ie; 1, 2, 3, 5, 0, 0, 8, 8, 4, 6, to where it shows 4.63 instead of 3.7. I want a running average for any point in time, whether I’m on cell A2 or A9, without regard to a cell with a zero value. Does anyone know of a formula that would allow me to do this? I can’t leave a cell blank either because it has a calculation in each of the cells already or that would be the easiest way. I’ve tried several different ways but I can’t seem to get it to work. Any help would be appreciated!
Thanks,
Jason
No comments:
Post a Comment