Hi,
I have a data validation that has 5,3 and N/A. But when I pick N/A in the dropdown menu the sum and average reads it a zero How do I assign N/A as still being 5 so it doesn't change the average later on?
Example:
Untitled.png
I want N/A to reflect as the maximum value in each drop down or for the formulas to ignore N/A and still calculate 100%
Thanks in Advance.
Bookmarks