» Counting Time Values in Terms of Hourly Increments
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
Counting the number of time values in List1 (column A) that occur between each pair of successive hours listed in column B.
Solution:
Use the COUNTIF function as shown in the following formula:
=COUNTIF($A$2:$A$7,">"&B2)-COUNTIF($A$2:$A$7,">"&B3)
Book Store:
Recommended Books:
No comments have been submitted.
