Sign in to join the conversation:
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) + "%)"
Change both of these portions
COUNT(CHILDREN())
to say
COUNTIFS(CHILDREN(), NOT(@cell = "N/A"))
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
Excellent! Happy to help.
Hello, Im working as a consultant/developer. Im signing up with multiple clients each with their own licenses. They are adding me as I work on their project. May I know if this is possible? Will they adding me have an issue on file/sheet/workspaces view and sharing? Any tips to avoid mixing up stuff? May I know if there…
Hi, We’re encountering errors when attempting to open an update request via email. Please see details below. Could you advise on the cause and next steps? Thanks
Where do I go to make sure my Workspaces are being backed up? It seems that currently only one of our Workspaces is being backed up.
