Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

addition in spreadsheet

Posted on 2011-10-13
6
Medium Priority
?
248 Views
Last Modified: 2012-05-12
Hi
How can I calculate the total of on column or one row in a spreadsheet like google doc or open Office
Thanks
0
Comment
Question by:speedtofly
  • 4
  • 2
6 Comments
 
LVL 33

Accepted Solution

by:
jppinto earned 2000 total points
ID: 36965656
Like this?

=SUM(A:A)
0
 

Author Comment

by:speedtofly
ID: 36965786
yes but how do you obtain a updated total at the bottom on a column every time you add an item?
0
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 2000 total points
ID: 36967225
For instance, if you have your list of values on column A and put the SUM formula on cell B1 for instance, it will sum all of the values that you enter on any row on column A, right?
0
[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

 

Author Comment

by:speedtofly
ID: 36967685
Ok but my question is" how do I set it up?"
0
 

Author Comment

by:speedtofly
ID: 36967691
Ok but my question is" how do I set it up?"
0
 

Author Comment

by:speedtofly
ID: 36993012
When I choose SUMM from the drop down menu option I see a formula
I copy and Pasted the formula =SUM(F:F) at the bottom of the column
But I have this error message
error: circular dependency detected

ANy suggestion?


0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Viewers will learn how to find and create templates in Excel 2013.
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data. Start with data in a poor structure: Create a table on your data: Unpivot columns: Rename columns: …

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question