Excel Formula Help

[spdpug98]

I have put a spreadsheet together to monitor my mileage / training on my MTB as I am in training for the South Downs Way 100-mile enduro in September.

Within the spreadsheet, I have two columns, one with ‘day’s mileage’ and the other with ‘mileage to date’. I have input a formula, which adds the ‘day’s mileage’ against the ‘mileage to date’ and updates the relevant cell; the problem is that I have copied the formula down the page which means that the whole of the column is populated with the mileage to date.

Is there a formula I could use to prevent the whole column being populated and staying at ‘0’ until a figure in the adjacent column is added, the formula currently used is basic ‘=SUM(E7+G6)’ and just copied down the columns

I hope this makes sense!

[markmullen]

=If(datecolumn>today(),(sum=mileagecolumn1:10),"")

[TonyHetherington]

Yup - use an "IF" statement (the Excel help is really good on this).

and then make one of the results "blank" (to enter blank type.... " " ) - does that make sense?

[TheGroover]

=IF(E7<>"",SUM(E7+G6),"")
If E7 is not blank, add E7 to G6, otherwise leave blank.

[mrmr96]

TheGroover said:

=IF(E7<>"",SUM(E7+G6),"")
If E7 is not blank, add E7 to G6, otherwise leave blank.

This is what I'd suggest.

[spdpug98]

TheGroover said:

=IF(E7<>"",SUM(E7+G6),"")
If E7 is not blank, add E7 to G6, otherwise leave blank.

Thank you, perfect