Formulas

[PCServices]

I need to figure out how many gallons sold at what price and what the total
dollor amount is for gallons total under a set price.

I have some experiance with formulas but I think this one I need help with.

Example:
Gallons|Price|Total Gallons|Total Gallon Price|
a2 b2 c3 d4
100 1.899 350 664.65
150
100

[Leith Ross]

Hello PCServices,

If these contain the following values:
A2 100
A3 150
A4 100
B2 1.899

These cells will contain the following formulas:
C3 =SUM(A2:A4)
D4 =C4*B2

Sincerely,
Leith Ross