none
Averageif Function RRS feed

  • General discussion

  • Yes I am trying to figure out an "averageif function" off of more than one criteria in the same column if it is even possible. If column "A" has the criteria & column "b" has times how can I get the average time between say three criteria? Example: Criteria column A = Car 1, Car 2 Car 3 Car 4 Car 5 Column B = Time 11:49, 10:30, 9:55, 7:24, 11:34 and so on through cells 1:50 I want the average time between Car 1, Car 3, Car 5 or should I be using a different function? Any help would be greatly appreciated!

    Friday, June 5, 2015 5:14 PM

All replies

  • The easiest way is to use a helper column, add this formula in C1

    =MATCH(A1,{"car 1";"car 3";"car 5"},0)

    and drag it down to the end of the data. Instead of the array {"car 1";"car 3";"car 5"} inside the formula, you can use some other cells to specify your criteria.

    Then the average formula is quite simple:

    =AVERAGEIF(C:C,">0",B:B)

    Andreas.

    Saturday, June 6, 2015 7:51 AM