={AVERAGE(IF(J7:J21<>0, J7:J21,""))}
Trying to use a array formula similar to the above to calculate an average of numbers from a column without including zero value fields in the average. but I am not successful.
Any ideas
={AVERAGE(IF(J7:J21<>0, J7:J21,""))}
Trying to use a array formula similar to the above to calculate an average of numbers from a column without including zero value fields in the average. but I am not successful.
Any ideas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks