Thread: ADD MONIES USIN EXCEL SPREAD SHEET

I would like to create a spread sheet for book keeping purposes at my church.
I am responsible for counting large sums of money and I would like to plug
in numbers and get a running total

valstraw, this will sum what's in column A, =SUM(A:A) , If this will not do
what you want post back with more details

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"valstraw" <valstraw@discussions.microsoft.com> wrote in message
news:21EB084F-3465-46F3-8F74-FDEC0E20A191@microsoft.com...
> I would like to create a spread sheet for book keeping purposes at my
church.
> I am responsible for counting large sums of money and I would like to
plug
> in numbers and get a running total

I find it best to keep the totals at the top, in row 2 say assuming row 1 is
a heading. The formula for this would then be

=SUM(OFFSET(A3,0,0,COUNTA(A3:A65536),1))

and every time you add a number at the foot of the column, it will add in

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Paul B" <to_much_spam_to_list@nospam.com> wrote in message
news:eDu3R%2313FHA.2816@tk2msftngp13.phx.gbl...
> valstraw, this will sum what's in column A, =SUM(A:A) , If this will not
do
> what you want post back with more details
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "valstraw" <valstraw@discussions.microsoft.com> wrote in message
> news:21EB084F-3465-46F3-8F74-FDEC0E20A191@microsoft.com...
> > I would like to create a spread sheet for book keeping purposes at my
> church.
> > I am responsible for counting large sums of money and I would like to
> plug
> > in numbers and get a running total
>
>