Not sure how to word this but here it goes..
I have a column(H) with how many miles out of route a driver went. The next column(I) is if the driver was due home or not.
on I45 I have a cell labeled "company OOR Average for drivers due home". I want this cell to have a formula that will average H25:H38, only if I25:I38 has "YES" in the cell, and plugs the information in I45.
I have attached a picture with the information above to give a better understanding.
Bookmarks