» 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:
- Financial Statement Analysis with S&P insert card
- Retire Young, Retire Rich
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- The Guide to Understanding Financial Statements
- Fish! A Remarkable Way to Boost Morale and Improve Results
No comments have been submitted.
