Brad, It will work either way. If you want the totals on a separate sheet, then use DATA - CONSOLIDATE and change the top box from SUM to AVERAGE. If you want to use a Pivot Table, drag the button into the data area of the grid and then double click the button to change it to AVERAGE. Jim Meagher ----- Original Message ----- From: "Brad Loomis" <[log in to unmask]> > Hi, > I recently got a new truck, and as I am somewhat anal and did this with my > previous car, (Except what I am trying to do here) I have created a gasoline > usage log in Excel. I have no problem making the table, entering the cost, > mileage, mpg etc. What I am unable to do is to have totals, and total > averages on a separate sheet. I can do this on the same sheet. It looks like > a pivot table may be the ticket, but I have been trying all afternoon to > make a functional one to no avail. It looks to me like the "average" formula > isn't available in a pivot table or I haven't a clue how to do it. So the > question(s) are: > How do I make a formula, or export data into an average on a separate sheet? > If I use a pivot table, how do I get it to do averages? > My table looks like this, (if it translates to email....) > > A B C > D E F > Date Price per gallon Miles Driven > Odometer Quantity MPG > 4/2/00 1.51 300 > 4325 15.3 19.2 > Etc. etc. etc. > > On sheet 2 I would like the total amount of gas, the average of my MPG, the > average of miles driven and the like. > Ie: > Column A Column B > Row1 Average MPG 20.32 from the "F" column on sheet above > Row2 Average Gallons 18.6 from the "E" column on sheet above > Etc.... > Thanks for any light an Excel expert can shed on this for me. > Brad Loomis > Los Angeles, CA > > PCSOFT maintains many useful files for download > visit our download web page at: > http://nospin.com/pc/files.html > PCSOFT maintains many useful files for download visit our download web page at: http://nospin.com/pc/files.html