TomSalvato
Technical User
Hello all,
I think what I'm trying to do is pretty straight forward, but I'm no excel expert (sadly).
I have three columns, I want the average of the contents, depending on how many columns are greater than zero.
So, if two of the three cells are greater than 0, I want to divide by 2. If only one of the three cells is greater than zero, then divide by 1. And if all three cells are greater than zero, divide by 3.
cell 1 cell 2 cell 3 formula result
4,524.69 1,047.38 875.61 2,149.23
1,293.62 577.08 0 935.34
0 612.02 0 612.02
Any help would be greatly appreciated!
-TS
I think what I'm trying to do is pretty straight forward, but I'm no excel expert (sadly).
I have three columns, I want the average of the contents, depending on how many columns are greater than zero.
So, if two of the three cells are greater than 0, I want to divide by 2. If only one of the three cells is greater than zero, then divide by 1. And if all three cells are greater than zero, divide by 3.
cell 1 cell 2 cell 3 formula result
4,524.69 1,047.38 875.61 2,149.23
1,293.62 577.08 0 935.34
0 612.02 0 612.02
Any help would be greatly appreciated!
-TS