input form and addition

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

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 news:[email protected]...
>
> 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
>
>
> --
> alexanderd
> ------------------------------------------------------------------------
> alexanderd's Profile:
http://www.excelforum.com/member.php...fo&userid=4984
> View this thread: http://www.excelforum.com/showthread...hreadid=388179
>

Originally Posted by Anne Troy

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 news:[email protected]...
>
> 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
>
>
> --
> alexanderd
> ------------------------------------------------------------------------
> alexanderd's Profile:
http://www.excelforum.com/member.php...fo&userid=4984
> View this thread: http://www.excelforum.com/showthread...hreadid=388179
>

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

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