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

=sum(A1:C1)/countif(A1:C1, ">0")

Thanks JFC

Works a treat!! You beauty

Twodogs

=TwoDogs/Two

Another handy tip for circumventing the evil 3-letter word "***".

Following on the same track as above still 3 columns but I want to only add the 2 highest columns together then average them. Can that be done easily? Obviously there still could be a 0 in one or more columns.

Twodogs

=sum(a1:c1)-min(a1:c1)

or

=max(a1:c1)+median(a1:c1)