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 ...
How to Use the IF Function in Excel
Tutorial: The IF statement is a simple yet powerful tool. Today we will go through how the IF functi...

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.