Welcome!

Exclude one item for the count

how can I exclude N/A on the count if N/A is selected

Formula:

=COUNTIF(CHILDREN(), "Done") + "/" + COUNT(CHILDREN()) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNT(CHILDREN()) * 100) + "%)"

Screen Shot 2019-04-19 at 10.34.36 AM.png

Find more posts tagged with

Comments

Paul Newcome

Change both of these portions

COUNT(CHILDREN())

to say

COUNTIFS(CHILDREN(), NOT(@cell = "N/A"))

Tribeiro

Perfect!

it worked!

Thank you Paul

Here is the new formula:

=COUNTIF(CHILDREN(), "Done") + "/" + COUNTIFS(CHILDREN(), NOT(@cell = "N/A")) + " (" + ROUND(COUNTIF(CHILDREN(), "Done") / COUNTIFS(CHILDREN(), NOT(@cell = "N/A")) * 100) + "%)"

Cheers

Paul Newcome

Excellent! Happy to help.

Sign in to join the conversation!

Trending discussions

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…