Excel Spread sheet query please
#1
![Post](https://www.scoobynet.com/images/icons/icon1.gif)
I currently do a spread sheet to work out my mpg (silly I know ;0 )
The last colum which gives me my MPG per tank but I want a field at the bottom to work out my average over every tankful !
The problem is that each time I fill up this field is altered
Please can someone tell me if there is a way that excel can count the number of fields & then divide the total amonts for the whole column by the number of rows !
I hope this makes sense
Cheers
Paul
The last colum which gives me my MPG per tank but I want a field at the bottom to work out my average over every tankful !
The problem is that each time I fill up this field is altered
Please can someone tell me if there is a way that excel can count the number of fields & then divide the total amonts for the whole column by the number of rows !
I hope this makes sense
Cheers
Paul
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM