How can i count values over a certain number for valid results only


I have 7 columns. Grab 1 Result, Grab 2 Result, Grab 3 Result, Grab 4 Result, Grab 5 Result, Grab 6 Result and Valid Results

I need to count the values greater than 200 if the valid result column = yes.

if the formula can be used for each column 1 through 6 in the sheet summary, I can just Sum to get my total.

I assume this can be done somehow. Thanks for the help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!