cell data

**byron jones** · 10-23-2011, 06:59 AM

hi can anyone please help
I have data in say column g1 to g30 which represents car mileage for each day of the month and I wish to view in another cell the end mileage of say g30 but becuse there are a different amount of days in month the end cell could be for ex g30 or say g29 is there a way to display the last entry of a column to anothr cell. Many thanks

**Andrew-R** · 10-23-2011, 07:18 AM

If you could post an example workbook then that would be great.

Are the mileages per day or are they a cumulative total mileage?

If it's per day then just =SUM(G1:G31) will work, because the SUM will ignore any blank lines at the end of the month.

If it's a cumulative mileage then probably =MAX(G1:G31)

**byron jones** · 10-23-2011, 10:41 AM

Originally Posted by Andrew-R

If you could post an example workbook then that would be great.

Are the mileages per day or are they a cumulative total mileage?

If it's per day then just =SUM(G1:G31) will work, because the SUM will ignore any blank lines at the end of the month.

If it's a cumulative mileage then probably =MAX(G1:G31)

Hi thanks for the reply here is a copy to where I am at the moment there is a macro in the sheet so you will have to accept macros all it does is move to each cell and then down after hitting the return cheers

**Andrew-R** · 10-23-2011, 10:55 AM

OK, so your end mileage formula is =MAX(F2:F35)

In the E column you could also use the formula =IF(A2<>"",F1,"")

That would put the starting mileage in for you automatically.

**byron jones** · 10-23-2011, 11:23 AM

Originally Posted by Andrew-R

OK, so your end mileage formula is =MAX(F2:F35)

In the E column you could also use the formula =IF(A2<>"",F1,"")

That would put the starting mileage in for you automatically.

Thanks for the first part that looks ok, but where you say the formula in the E column would put the start mileage in for the next day if I have done any private miles between finishing on the night and starting the next morning on business they need to be added up and totalled at the bottom on the page where it says private mileage for this period.

The idea of the spread sheet is so that the company can charge me for private miles for use of the company car and they need documentation for tax purposes. I have tried to explain it best as I can and hope you understand what I am after.

Many thanks for your help up to now.

**byron jones** · 10-23-2011, 11:42 AM

Originally Posted by byron jones

Thanks for the first part that looks ok, but where you say the formula in the E column would put the start mileage in for the next day if I have done any private miles between finishing on the night and starting the next morning on business they need to be added up and totalled at the bottom on the page where it says private mileage for this period.

The idea of the spread sheet is so that the company can charge me for private miles for use of the company car and they need documentation for tax purposes. I have tried to explain it best as I can and hope you understand what I am after.

Many thanks for your help up to now.

Ihave sorted out the last bit so i'm done now thanks for the speedy reply and help