D
danny boahn
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.
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.