I am sure this is rather obvious, however I am not seeing where my mistake is. All I am trying to do is return the average cost of a product cost column but I need to not include any $0.00 dollar amounts that are populating (which will happen when there is no inventory at the moment). Can someone please advise where my mistake is?
=AVG([Protocol Cost w/ Freight]:[Protocol Cost w/ Freight], <>0)
Thank you