[Solved] What Function do I need and how to implement it.

[Banazauk]

Hi everyone

I need some help with what function I need to use and how to implement it. I don't really use so I'm not sure how they work. I've tried searching, but as I don't know what I'm looking for, it has been fruitless.

I'm working on a sheet that shows how many miles a wagon has ran for the week. I want a function that will work add together the total miles that it ran when it was carrying goods and a total mileage for when it was travelling empty, e.g. going from the last drop to collect the next load. I have linked to an image of the sheet that I need help with below.

When there is an E in the column to the right of the miles, I want it so it only totals the cells to the left of the E, and vice versa for loaded miles which will be left blank in the same column.



Thanks in advance.

Martyn

[FJCC]

The attached file shows two way to use formulas for this, once with SUMPRODUCT() and once with SUMIF(). SUMPRODUCT() is the more flexible method.

[Banazauk]

Thanks. I'll have a look and see if I can understand it.