So I have a column with number of trips, another with number of vehicles and another with number of people.
I need to find the average of the number of trips WHEN number of vehicles is greater than 0 BUT number of workers is greater than the number of vehicles.
I have been using averageifs for this. Do anyone have any ideas what the code might look like?
I have tried =ANSWERIFS(A:A, B:B, ">0", C:C, ">"&B:B) but I am not having any luck.
Please could someone help?
V7
I need to find the average of the number of trips WHEN number of vehicles is greater than 0 BUT number of workers is greater than the number of vehicles.
I have been using averageifs for this. Do anyone have any ideas what the code might look like?
I have tried =ANSWERIFS(A:A, B:B, ">0", C:C, ">"&B:B) but I am not having any luck.
Please could someone help?
V7