Forum Discussion
Solved
Why is this failing?
https://imgur.com/a/oQJG6HY =AVERAGE(IF(D3:J3<>0 AND D3:J3<>"",D3:J3,"")) Trying to get an average for d3:j3, if zero or blank do not average, if "pto" use 9 instead. Started with bing faile...
Skeletor35 This one if you also want to take the "pto" into account:
=AVERAGE(IF(D3:J3<>"pto",IF(D3:J3<>0,D3:J3,""),9))
Skeletor35 This one if you also want to take the "pto" into account:
=AVERAGE(IF(D3:J3<>"pto",IF(D3:J3<>0,D3:J3,""),9))
Thank you sirs!! I greatly appreciate your help on this matter! They both work perfectly! Thanks again
