NOT UNDERSTANDING THE FORMULA
 

SORRY = here is the problem clearly stated:
A: filling in a Order Sheet
1. coloum a2,3,4,5 will be the Quanities of each item
2. column g2,3,4,5 will be the unit prices of each item
3. column h2 will consist of the result of a2*g2
thus this formula would repeat itself throughout column "H" this if

A2 is 5 chairs
G2 is $10.00 each
H2 would be $50.00
"eXAMPLE" H14 would be the totals of coloums h2-h13 would be Place in h14

thus this is your standard odering form:

I've read your info that states col. A has the number of items, col. G
has unit prices and col. H is the multiple of A and G to yield total $
for each row. Then you SUM col. H to calculate the total $ involved.
You have presented the facts, so what is the question? GeorgeF


--
GeorgeF
------------------------------------------------------------------------
GeorgeF's Profile: http://www.excelforum.com/member.php...o&userid=24124
View this thread: http://www.excelforum.com/showthread...hreadid=466793