» Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Example, the numbers in cells A1:A7 are 24,35,36,38,37,48,42. The criteria - count the numbers between 30 and 40 (30 < x < 40) Enter the criteria in cells B1 and B2 The Formula: =COUNTIF(A1:A7,">"&B1)-COUNTIF(A1:A7,">"&B2) The result: 4
Book Store:
Recommended Books:
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Investing for Dummies, Third Edition
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Windows XP for Dummies
No comments have been submitted.
