Forum Discussion
Formula request
The table attached is a simple illustration of the question, What is the formula in G8 etc that would recognise E8 as being greater than 90 and therefore convert to a '1'?
Anyone's help greatly appreciated.
In G7:
=IF(E7>90,1,"")
Fill down.
But if you want the number of cells in E7:E22 whose value is greater than 90, you don't need those helper formulas. The single formula
=COUNTIF(E7:E22, ">90")
will return that number.
- Thanks so much Hans - perfect!!
