This formula calculates the average of "product a" if column W includes "consumer", if column V includes contents of cell AJ17 and if column M is not blank:
But if the parameters are not met (say AJ17 is not found in column V), I recieve a "#DIV/0!" error in where the average cannot be calculated.Please Login or Register to view this content.
What I would like is to include a "-" where average cannot be calcualted instead of the "#DIV/0!" error.
Is this possible?
Bookmarks