Hello,

I have a function that averages the grades in a column. Part of the function needs to use the code function. It returns #VALUE! whenever I have an empty cell in the range.

For example
CODE(A1:A5)
If A4 is blank, then it will return an error.

How do I make it so that it doesn't count the blanks?