Ignoring Blank Cells
How do I make this formula ignore blank cells? I want it to total the percent of YES cells to NO in a range.
=COUNTIFS(CHILDREN(), OR(@cell = "YES", @cell = "No aplica")) / COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> ""))
Best Answer
-
Hi @Alishia Topper,
Try this:
=COUNTIF(CHILDREN(), "YES") / COUNTIF(CHILDREN(), <> "")
This will count how many children say "Yes" out of all the children that are not blank (or counting the total of both Yes and No). Is that what you're looking for?
Here's some information on COUNTIF and on CHILDREN.
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Here is a image of the worksheet. The formula I'm referencing is the 0.33333 in the Count column.
-
Hi @Alishia Topper,
Try this:
=COUNTIF(CHILDREN(), "YES") / COUNTIF(CHILDREN(), <> "")
This will count how many children say "Yes" out of all the children that are not blank (or counting the total of both Yes and No). Is that what you're looking for?
Here's some information on COUNTIF and on CHILDREN.
Let me know if this works for you!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
This answer worked perfectly and thank you! for providing additional information.
-
Wonderful!! So glad it worked for you.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!