{"id":150,"date":"2011-04-04T07:46:59","date_gmt":"2011-04-04T12:46:59","guid":{"rendered":"http:\/\/www.properwichita.com\/consulting\/?p=150"},"modified":"2011-04-27T23:05:24","modified_gmt":"2011-04-28T04:05:24","slug":"tip-autosum-in-excel-2010-adding-it-up","status":"publish","type":"post","link":"http:\/\/www.properwichita.com\/consulting\/2011\/04\/04\/tip-autosum-in-excel-2010-adding-it-up\/","title":{"rendered":"Tip: Autosum in Excel 2010 – Adding It Up"},"content":{"rendered":"

As a Wichita IT support professional, I see a number of users mystified by using Microsoft Excel.\u00a0 This powerful spreadsheet tool can be used for a number of things, the least of which is adding up the numbers, but that’s where we will start.<\/p>\n

Creating complex formulae in Excel doesn’t require an information technology support specialist, even less so for something simple like adding up the numbers in a column.\u00a0 Here’s the quick and easy method, without the need for memorizing how to craft a formula.<\/p>\n

Step 1:<\/strong> Identify the group of numbers you wish to add. I’ll start with a simple spreadsheet listing the days of the week.<\/p>\n

\"A

A Sample Spreadsheet<\/p><\/div>\n

We need to calculate the total sales for the week in the highlighted box.<\/p>\n

Step 2: <\/strong>Click the Formula<\/strong> tab on the menu bar and select Autosum<\/strong>.\u00a0 Click the down arrow to see your options.<\/p>\n

\"The<\/p>\n

\n
\n
The Autosum Feature on the Formula Menu<\/dd>\n<\/dl>\n<\/div>\n

Step 3: <\/strong>Choose the correct function.\u00a0 I’m choosing Sum<\/strong> as I want a total.\u00a0 Notice that my column is highlighted.<\/p>\n

\"The

The Formula is Created<\/p><\/div>\n

Step 4: <\/strong>Hit Enter<\/strong> to accept the formula.<\/p>\n

We now have the correct formula and the total is correct.\u00a0 Use the same steps above, but experiment with the options.\u00a0 You can do averages, show the high and low values of the column, the count of numbers in the column and many others.<\/p>\n

For IT support in Wichita, including 1 on 1 and individual training, call Proper Technology Solutions at (316) 337-5628 or our after hours support line at (316) 210-7112.\u00a0 We try to demystify Information Technology to provide your business with the support you need to make your technology more efficient.<\/p>\n

Don’t forget to register for our Lunch and Learn on April 21st from Noon-2pm.\u00a0 It’s a free opportunity to stop by and learn how to leverage Office 2010 in a casual environment.<\/p>\n","protected":false},"excerpt":{"rendered":"

As a Wichita IT support professional, I see a number of users mystified by using Microsoft Excel.\u00a0 This powerful spreadsheet tool can be used for a number of things, the least of which is adding up the numbers, but that’s … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4,5,134],"tags":[32,31,9,7],"_links":{"self":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/150"}],"collection":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/comments?post=150"}],"version-history":[{"count":2,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/150\/revisions"}],"predecessor-version":[{"id":254,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/posts\/150\/revisions\/254"}],"wp:attachment":[{"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/media?parent=150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/categories?post=150"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.properwichita.com\/consulting\/wp-json\/wp\/v2\/tags?post=150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}