» 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 New Financial Order: Risk in the Twenty-First Century
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- A Mathematician Plays the Stock Market
- Seven Habits Of Highly Effective People
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
No comments have been submitted.
