Good Morning,

I am trying something new and I am unsure it can be be done but worth asking all the same.

What I have is 3 columns with numbers from 0 to 24. What I want to do is in a fourth column have columns 1 to 3 added together and devided by 3 to get a average. But when one of the columns has a 0 I don't want to include it in the calculation. So if there are only two columns with numbers 1 to 24 I would like to only devide by 2 rather than 3. Hope that makes sense. Can it be done??

Thanks
Twodogs