# Need Formula to count if cell values are Greater than 0.5

Options
edited 12/09/19

I have tried several different formulas to determine how many cells have a value greater than 0.5.  The cells are qtr 1, qtr2, qtr3, qtr4, qtr5, qtr6, qtr7, and qtr8.  The cells are not next to each other so it can not be a range.  Any suggesstions?

Forrest

Tags:

• ✭✭✭✭✭✭
edited 01/11/19
Options

Hi Forrest,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• edited 01/11/19
Options

screen shot attached.  The 3 for # of outperforming qtrs was entered manually. This is where I need the formula

• ✭✭
edited 01/14/19
Options

You could use COUNTIFS to check for values greater than 0.5 in columns where the first row contains "QTR":

=COUNTIFS([qtr 1]2:[qtr8]2, >0.5, [qtr 1]1:[qtr8]1, FIND("QTR", @cell) > 0)

Edit: After I posted this, I realized that it should be probably be adjusted to lock the first row cells in place:

=COUNTIFS([qtr 1]2:[qtr8]2, >0.5, \$[qtr 1]\$1:\$[qtr8]\$1, FIND("QTR", @cell) > 0)

• Options

Thank you, the second formula worked!

• Options

I have a similar problem but instead of several columns it is several rows in one column.  I need to figure out how to determine how many cells are greater than 50% (green) out of the ? participating units.  Row 16 shows manually there are 7 above 50% out of 9 participating units noted in row 17.  I attached a screen shot.  There are rows of data that are between each that have the specific data for that unit so the formula can not be a simple range.  Can you assist?

• ✭✭✭✭✭✭
Options

Hi Forrest,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!