» Using Date & Time Criteria to Count Entries in a Combined Date & Time List
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Problem:Column A contains date and time values.
We want to count the number of entries with matching date criteria (cell B2) and a time value greater than the one specified in cell C2.
Solution:
Use the SUMPRODUCT, INT, and MOD functions as shown in the following formula:
=SUMPRODUCT((INT(A2:A6)=B2)*(MOD(A2:A6,1)>C2))
Book Store:
Recommended Books:
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Office XP Introductory Concepts and Techniques
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Access Version 2002 Step by Step
No comments have been submitted.
