Excel Forum
Similar Content
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
SUMIFS - Sum Values Based on Multiple Criteria in Excel
Tutorial: The SUMIFS function allows you to sum values that meet multiple criteria across multiple ...
Logical Operators in Excel VBA Macros
Tutorial: Logical operators in VBA allow you to make decisions when certain conditions are met. They...



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.