Hi Everyone,
Please see the attached image of the spreadsheet I am working on, hopefully this will make sense.
I'm trying to work out the formula needed to take the values in each column ranging from B - D dependent on whether its corresponding route number in column A is odd or even and then calculate the average (mean) value of that column while ignoring any cells with a 0 value.
Spreadsheet 1.jpg
Thank you in advance for any help you can give
Bookmarks