Hello
I am trying to average a range of data; however, I want to exclude zeros. The data range is non sequential. There is other information in the way so I can't select a full range.
I get the error that " You've entered too many arguments for this function"
=averageif(E2,M2,U2,AC2,AK2,<>0)
In the sample attached I want to average out the "average price"
Thanks in advance.
Bookmarks