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
If A4 is blank, then it will return an error.CODE(A1:A5)
How do I make it so that it doesn't count the blanks?
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks