I'm trying to see if there is a way to get an average of three cells but in some cases one or two of the 3 cells will be zero and I want it to average accordingly to the amount of cells with a value in them for example:
150 , 154 , 140 = 148 this gets divided by 3 values entered
150 , 154 , 0 = 101 this gets divided by 3 values but there are only two entered, I need it to divide by 2 only
150 , 0 , 0 = 50 should be 150 if divided by only 1 value entered
If anybody can understand what I just wrote please help me
150 , 154 , 140 = 148 this gets divided by 3 values entered
150 , 154 , 0 = 101 this gets divided by 3 values but there are only two entered, I need it to divide by 2 only
150 , 0 , 0 = 50 should be 150 if divided by only 1 value entered
If anybody can understand what I just wrote please help me