How do I write a formula to average the cells that are >89% and <100%?

Jess A

bisaacs

Hey @Jess A,

Try this formula:

=(SUMIFS([%]:[%], [%]:[%], <1, [%]:[%], >0.89)) / (COUNTIFS([%]:[%], <1, [%]:[%], >0.89))

Hope this helps!

bisaacs

Hey @Jess A,

Try this formula:

=(SUMIFS([%]:[%], [%]:[%], <1, [%]:[%], >0.89)) / (COUNTIFS([%]:[%], <1, [%]:[%], >0.89))

Hope this helps!

Jess A

@bisaacs

Thank you that worked.

How would if count those that fit the same criteria then divided by total count of resources?

bisaacs

Hey @Jess A,

You mean to count the whole column of percentages? You'd change the COUNTIFS to COUNT:

=(SUMIFS([%]:[%], [%]:[%], <1, [%]:[%], >0.89)) / (COUNT([%]:[%])

Jess A

@bisaacs Thank you.