My spreadsheet has 3 columns and 20 rows:
- Column 1 = ODO meter readings (distance travelled from point A to point B).
- Column 2 = Private use.
- Column 3 = Business use.
I want to total Column 2 as follows: IF column 2 = Private use, it must add the ODO meter reading in column 1 or IF column 3 = Business use, it must add the ODO meter reading in column 1.
I would like to attach the spreadsheet in order for you to get a better understanding, but it seems it is not possible at this stage.