input form and addition

A

alexanderd

i have an input form in which 6 rows of data intern give a sub total.
what i would like to do is have a running / grand total
automatically.

p2 =20
z2 =18 Grand total would read = 38
ac2 = 1 Grand total would read = 39
ad2 = 4 Grand total would read = 43
aj2 = 3 Grand total would read = 46
az = 2
Grand total = 48

can any one suggest a solution
 
A

alexanderd

Anne said:
Assuming all your values are in B column, have you tried =sum(B:B)?
*******************
~Anne Troy

www.OfficeArticles.com


"alexanderd" <[email protected]>
wrote
in message
Click to expand...
no as yo can see this is part of a form in which the values are reached
by muliplying the input values of two textboxes togrther to give a sub
total.
i then want to add all the subtotals together as a grand total still on
the form
 
A

alexanderd

thank you for trying to help me, what i should have done is included a
attachment .............. i have done that now and resolved what i wa
looking for

+-------------------------------------------------------------------
|Filename: Addition.zip
|Download: http://www.excelforum.com/attachment.php?postid=3611
+-------------------------------------------------------------------
 
Top