CountIf/CountIFS/Sumproduct Not Displaying desired results.

The values in column B are text. Also true of the values in column G.

Select the values in column B, click Data > Text To Columns > Finish. Repeat for column G.

FYI, since Excel time cannot be negative, it is sufficient to test COUNTIF(D1:D12, "<=0:30") or COUNTIF($D$1:$D$12, "<=" & I3).

But if you want to count the times in D1:D12 that are between two intervals in column I, enter (the following into J4 and copy down the column:

=COUNTIFS($D$1:$D$12, ">" & I3, $D$1:$D$D12, "<=" & I4)

I'm not an expert in "time" in Excel, but maybe it has to do with how the time in column D is entered. When I selected that column, I selected the format of time (in format of 13:30) and then I RE-ENTERED the same values, you formulas worked (actually, your countifs formula is pointing to Col B, not Col D, but if you change it to Col D, then it also works.)

.
This works for J3 :

Please Login or Register  to view this content.