Exclude one item for the count

Tribeiro

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) + "%)"

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.