Percentage Formula
I have this formula that calculates the percentage of items in a column where the check box "**Approved to Order" is checked, and it only counts items that have a quantity of 1 or greater than one.
We are moving the check box to a Status column with many options, so I changed the formula but it is not working. Can anyone adjust it for me? Thank you!
=(COUNTIF([**Approved to ORDER]:[**Approved to ORDER], 1)) / (COUNTIF([**QTY]:[**QTY],
=(COUNTIF([Status@row = "Approved to Order"]:[Status@row = "Approved to Order"], 1)) / (COUNTIF([**QTY]:[**QTY], >=1))
Best Answers
-
I figured it out, thanks!
=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))
-
Hi @Randy Sherwood,
Try this
=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)
Answers
-
I figured it out, thanks!
=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))
-
Hi @Randy Sherwood,
Try this
=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)
-
Thanks Devin,
I appreciate the simplified version.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!