Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
ADD MONIES USIN EXCEL SPREAD SHEET
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" wrote in message ... 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 |
#3
|
|||
|
|||
ADD MONIES USIN EXCEL SPREAD SHEET
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" wrote in message ... 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a excel spread sheet using ffinancial functions | Excel Worksheet Functions | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
is there anyway to make it so the users of my excel spread sheet cant view the macro code w/o a password? | Excel Worksheet Functions | |||
How do I export excel spread sheet to my Palm T3? | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |