Excel Forum

Excel Magic Trick #127: Count Less Than 70% of Max

See how to create two different formulas for counting items that are less than 70% of the max. See a COUNTIF function that uses the ampersand and an Array formula.

Got a Question? Ask it Here in the Forum.