I've got an Excel spreadsheet with my mileage along with a few other details. One of the columns is which bike I rode. What I want to do is total up the mileage for each bike.

Column K has the bike noted, A, B, C etc and column C has the mileage for that particular ride.

What I want to do is have a cell at the bottom of the month sheet with the total mileage for Bike A, B & C

## Excel Formula help.

### Re: Excel Formula help.

Simplest would be to use. SUMIF just look in help for the syntax.

NUKe

_____________________________________

_____________________________________

### Re: Excel Formula help.

Hi

Mine look like this with a separate tab for each bike, but otherwise sounds the same as yours

The function (SUM) that I used is shown in the formula bar

You seem to have a single sheet for each month. If you want a total mileage for all three bikes, as opposed to each of your bikes, then you could run SUM on each column total

Regards

tim-b

Mine look like this with a separate tab for each bike, but otherwise sounds the same as yours

The function (SUM) that I used is shown in the formula bar

You seem to have a single sheet for each month. If you want a total mileage for all three bikes, as opposed to each of your bikes, then you could run SUM on each column total

Regards

tim-b

~~~~¯\(ツ)/¯~~~~

### Re: Excel Formula help.

Take a look at pivot tables. They take a bit of work to understand to start but is worth the effort.

Barry

Barry

--

Cheers

Barry

Cheers

Barry

### Re: Excel Formula help.

Taken from a similar exercise but nothing to do with cycling

=SUMIF(C2:C62,"Red",E2:E62)

If Red appears in the range C2 to C62 (could be red bike) then add up the appropriate cells in the range E2 to E62

=SUMIF(C2:C62,"Red",E2:E62)

If Red appears in the range C2 to C62 (could be red bike) then add up the appropriate cells in the range E2 to E62

### Re: Excel Formula help.

When you have the individual mileages for several bikes for consecutive years, you could draw a ‘Waterfall’ chart displaying the decrements and gains of mileage for each bike.

### Re: Excel Formula help.

What you want is (assuming there are 100 rows in the spreadsheet. Change yours to suit)

Code: Select all

`Total for bike 'A':`

=SUMIF($K1:$K100,"A",$C1:$C100)

Total for bike 'B':

=SUMIF($K1:$K100,"B",$C1:$C100)

Total for bike 'C':

=SUMIF($K1:$K100,"C",$C1:$C100)

The hurrier I go, the behinder I get

### Re: Excel Formula help.

I use

(which gives me a text 999 Miles)

Ian

=FIXED(SUMIF($N$8:$N$1000,$I$2, $B$8:$B$1000),0,TRUE)&" Miles"

(which gives me a text 999 Miles)

Ian

### Re: Excel Formula help.

I went with NUKe's suggestion of SUMIF, a quick Google last night got me the formula and I just entered my own criteria to suit.

Cheers all.

Cheers all.

### Re: Excel Formula help.

Do have a look at pivot tables, then break the date up - year, month, dow.

Then you can make some interesting tables

Then you can make some interesting tables

A shortcut has to be a challenge, otherwise it would just be the way. No situation is so dire that panic cannot make it worse.

There are two kinds of people in this world: those can extrapolate from incomplete data.

There are two kinds of people in this world: those can extrapolate from incomplete data.