I have a set of data like that shown below. I am trying to do an average ifs for this data to average the number of trips, the amount of vehicles must be bigger than 0 AND the number of vehicles must equal the amount of people. what is the formula in order to do this?
I am able to write the formula for if greater than zero, but I am having difficulty finding out how to say that the value in one column (vehicles) must equal the one in the next (people)
Bookmarks