COUNTIF functions - Help with formula

[Troutner]

I need to determine the number of occurrences in my spreadsheet of how many trips (Cell E2,E60, see attached spreadsheet) were under 10 minutes, how many were 10-20, how many were 20-30, and how many were over 1:00 hour. I thought I needed to do this as a CountIF formula with a greater than, less than equation. However, I keep getting an error message on my value.

My ultimate goal is to prepare a bar chart showing the number of trips in a given time for each of my drivers.

Please help? I have attached a sample copy of the data.

Thank you.

[Jonmo1]

Try

Less than 10
=COUNTIF(D:D,"<0:10:00")

10-20
=COUNTIFS(D:D,">=0:10:00",D:D,"<0:20:00")


That should be enough to get you going.

[FDibbins]

for the 1st 1 (10)...
=COUNTIF(E:E,"<10")
for the others, modify this as needed...
=COUNTIFS(E:E,">=10",E:E,"<20")

[Troutner]

Formulas provided worked great, except when I check my totals, I do not get the same total number as the amount of rows that I have. I have entered the formulas in cells J2 - P2 (see attached spreadsheet). I sorted my spreadsheet by trip time to spot check to make sure that I was getting all trip times. I have 406 rows, minus my header row, leaving 405 trips. There are several cells with blank trip times, however when I auto sum J2-P2, I come up 372 trips, when I should have 406.

What am I doing wrong here? Any help would be appreciated?

Thank you SO MUCH! This forum is AWESOME!