Percentage Formula

Randy Sherwood

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))

Randy Sherwood

I figured it out, thanks!

=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))

Devin Lee

Hi @Randy Sherwood,

Try this

=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)

Randy Sherwood

I figured it out, thanks!

=(COUNTIFS(Status:Status, HAS(@cell, "Approved to Order")) / (COUNTIF([**QTY]:[**QTY], >=1)))

Devin Lee

Hi @Randy Sherwood,

Try this

=COUNTIF(Status:Status, "Approved to Order") / COUNTIF([**QTY]:[**QTY], >=1)

Randy Sherwood

Thanks Devin,

I appreciate the simplified version.