» Count the number of times dates in certain month appears in range in Microsoft Excel
CATEGORY - Counting , Excel Array Formulas
VERSION - All Microsoft Excel Versions
Dates in cells in Column A, Conditions are in cells B2:C3 :
| A | B | C | |
| 1 | Dates | Month Number | Year |
| 2 | 01/03/2003 | 1 | 2003 |
| 3 | 02/05/2003 | 2 | 2000 |
| 4 | 03/12/2003 | ||
| 5 | 03/24/2000 | ||
| 6 | 02/15/2000 | ||
| 7 | 01/18/2003 | ||
| 8 | 04/12/2003 | ||
| 9 | 03/24/2000 | ||
| 10 | 02/15/2000 | ||
| 11 | 01/22/2003 |
Formula in cell D1: {=SUM((MONTH(A2:A11)=B2)*(YEAR(A2:A11)=C2)*1)}
Result: 3
Please note:
The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter
Book Store:
Recommended Books:
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- East of Eden (Oprah's Book Club)
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.
