Excel

G

Guest

I am doing a spread sheet on tires. I am tracking mileage, how much of the
tire is worn. and the average mileage you can get out of the tire. This is
going to be a weekly thing I am tracking. I will have 4 lines of data on each
vehicle I am tracking. I have set up my spread sheet in rows. In cell b2 I
enter the mileage of the truck, in c2 i enter the 32nd of the left front tire
in d2 i enter the 32nd of the right front tire. In cell e2 I have a formula
to give me the average 32nd left on the tires. in f2 i have a formula that
gives me the average mileage per 32nd and in g2 i have a formula that gives
me the projected mileage. I want to set up a summery sheet but my problem is
that I have the totals set up to appear in cell e6[=sum(e2)], f6[=sum(f2)],
and g6[=sum(g2)].What I need to happen when I go to enter new data in b3, c3,
d3, and that data gets totaled in e3, f3, and g3 I want those totals to
appear in cells e6, f6, and g6 and not the totals from e2, f2 and g2 anymore.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top