Hi, new to the forum, been trying to pick up some advanced functions by reading and watching examples online (YouTube, Lynda.com etc., but none really speak to my problem...

So, I've got a table of roughly 20,000 rows and 30 columns of data. The two columns I am interested in are the ones titled "Driver" (in the B column) and "Idle Time" (in the R column). Each driver has multiple entries in the table of data, so I am trying to get an average "Idle Time" for each driver.

The first driver, "Aaron Anderson" for instance has approximately 209 entries so I used this formula:

=AVERAGE(R2:R211)

which produced his average. It quickly got very tedious to find the start and end fields for each of the nearly 100 drivers, so figured I might be able to improve my efficiency if I could get a more advanced formula in place - started researching and learned about AVERAGE IF

I watched a few videos and read some details on Microsoft help pages and believe I've got it conceptually:

AVERAGEIF(RANGE OF CELLS TO AVERAGE, LIMITER CRITERIA, and optionally the ACTUAL CELLS TO BE USED).

Since I was already using the actual cells, and the limiter criteria seemed to be what I would need, I tried this:

=AVERAGEIF(R2:R20068,"Aaron Anderson")

but got the dreaded #DIV/0 error.

So, I tried modifying the formula to specify both the Driver header title and the column letter

=AVERAGEIF(R2:R20068,Driver="Aaron Anderson")

=AVERAGEIF(R2:R20068,B="Aaron Anderson")

Same results...my head is starting to hurt. So, can someone help me correct my construction here?