Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
COUNT where cells <>"N/A"
I'm struggling to combine a SUM and a COUNT together (keeps returning an error).
=SUM([CELL 1]22:[CELL 4]22) / COUNTIF([CELL 1]22:[CELL 4]22, <>"N/A")
This returns a #DIVIDE BY ZERO.
CELL 1 to CELL 4 could contain the numbers 1 to 5 or N/A.
The end result is to provide a percentage out of 100% for the total cells with a number.
Sure I'm doing something stupid
Any assistance would be appreciated.