Feb 13 2019 04:25 AM - edited Feb 13 2019 04:26 AM
Hi there! Do the following:
=average(j1,p1,s1,v1) assuming that all these cells contain numbers in the columns you have just stated. You may also net the formula with an IFERROR, so as to prevent any invalid data error, especially if one of the cells in the average formula is blank. So =IFERROR(Average(J1,P1,S1,V1),0) (in that case the error result would be 0). Hope this helps in someway
Feb 17 2019 10:02 PM
Hi. Thank you for the replay!
Is it possible to calculate a average on only the cells with a value more than 0?