» Using Date & Time Criteria to Count Entries in a Combined Date & Time List
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
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:
- The 11 Immutable Laws of Internet Branding
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Office XP Introductory Concepts and Techniques
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
- Not-for-Profit Accounting Made Easy
- Microsoft Word Version 2002 Inside Out
No comments have been submitted.
