I am trying to get the average of percentages in every other cell, excluding those cells with a 0. I tried this formula.


I get this error. "Wrong number of arguments to AVERAGEIF. Expected between 2 and 3 arguments, but got 21 arguments."

What am I doing wrong? Thank you for your help!

1 Answer 1


AVERAGEIF has the following syntax:

AVERAGEIF(criteria_range, criterion, [average_range])

Arguments are in parentheses, separated by commas. An optional argument is enclosed in square brackets. Therefore, you get the message: "Expected between 2 and 3 arguments".



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.