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.