Help with Sumif not recognizing criteria as a percentage

frankpkp

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

SmSulli

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

 

J. Craig Williams

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

Craig