» Counting the Number of Values Below or Above Average
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Counting the number of values in List1 (column A) that are below the range's average, as well as the number of values above average.
Solution:
Use the COUNTIF and AVERAGE functions as shown in the following formulas:
To count values below average:
=COUNTIF(A2:A9,"<"&AVERAGE(A2:A9))
To count values above average:
=COUNTIF(A2:A9,">"&AVERAGE(A2:A9))
Book Store:
Recommended Books:
- Guide to Financial Reporting and Analysis
- The One Page Business Plan: Start With a Vision, Build a Company!
- The Fall of Advertising and the Rise of PR
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Monte Carlo Methods in Finance
No comments have been submitted.
