#### Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

# Help with Sumif not recognizing criteria as a percentage

Options
edited 12/09/19

Hi all,

Trying to create a field that will tell me what percent of a list of values have exceeded 80%.

=SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7)

Goal progress is a percent value i.e. 100% or 45%

80% Value is the number 1

Smartsheet is not recogonizing the criteria "80%" nor does it recognize ".8"; it will work with a whole number.

Am I stuck?  Any way around this?

thanks - Frank

• Options

Not 100% sure if this is what will work for you.  Format the column as %.

=(COUNTIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]16, >=0.8)) / (COUNTIF([Goal Progress 2017-2018]1:[Goal Progress 2017-2018]16, ISNUMBER(@cell)))

Good Luck

Shawn

• ✭✭✭✭✭✭
Options

Don't use quotes when your criterion is a number.

Craig

This discussion has been closed.