Formulas
 

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

Formulas
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=512051