Microsoft Office Tutorials and References
In Depth Information
Ratio of height to time in column H
Assume that all runners whose height in inches is less than their time in minutes will get an award. How
many awards are needed? If the ratio is less than 1, an award is warranted. The COUNTIF function in cell
G18 computes a count of ratios less than 1, as shown in Figure E-25.
COUNTIF function used in cell G18