{"id":679,"date":"2012-10-02T11:42:10","date_gmt":"2012-10-02T11:42:10","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=679"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"let-excel-do-the-number-crunching-with-autosum","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/let-excel-do-the-number-crunching-with-autosum\/","title":{"rendered":"Excel Training: Let Excel do the number-crunching with Autosum"},"content":{"rendered":"

For those of us who can break out into a cold sweat at the mere mention of a “formula”, Excel has functions already set up to remove the need for towels and darkened rooms.<\/p>\n

I use Excel’s common functions every day – autosum, averages, count and minimum and maximum – all I have to do is select the cells I want, and select the function. \u00a0This makes it incredibly quick and easy to get answers – without the need for me to write in formulas.<\/p>\n

With only 83 days to go until Christmas (!) let’s imagine that a team has been asked to write their wish list for Santa. \u00a0As Santa’s office elf, I then collect the wishes and need to work out how much the wishes cost, and tell my boss how much the total is, what the average is, so that he can decide whether Santa should grant the wishes or take some poetic licence on what everyone gets….<\/p>\n

My excel sheet looks like this:<\/p>\n

\"Excel<\/a>
Excel sheet showing the basic information for the Secret Santa wishlist…Santa’s elf now needs to work out the costs to see if Santa can afford all the presents….<\/figcaption><\/figure>\n

I now want to use autosum to find the total cost of wishes…so I select the cell immediately below the column of data (cell C7). \u00a0I then click on the formulas tab, and click autosum, in the Function Library group.<\/p>\n

So the screen now looks like this:<\/p>\n

\"Excel<\/a>
Screenshot of autosum calculation<\/figcaption><\/figure>\n

Now Santa knows that the total cost is \u00a385.75. \u00a0But there has been a record number of people on the nice list, so Santa only has a \u00a370 budget, so the elves have checked if they can source cheaper options for the same items…and they’ve added this to the worksheet, and used autosum again to find the total.<\/p>\n

\"Screenshot<\/a>
Screenshot of Santa’s reduced cost wishlist with autosum and averages<\/figcaption><\/figure>\n

 <\/p>\n

But this time, I access autosum by highlighting the cells, and looking in the bottom right corner of my worksheet. \u00a0From this, I can see that the average cost per gift is \u00a37.71 for 5 items, and the total cost is the Sum \u00a338.53.<\/p>\n

\"Excel-training-quick-<\/a><\/p>\n

\n
<\/dt>\n<\/dl>\n

So thrifty Santa knows that he can now give everyone their gift, under budget, as long as they stay on the nice list until Christmas Eve.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

For those of us who can break out into a cold sweat at the mere mention of a “formula”, Excel has functions already set up to remove the need for towels and darkened rooms. I use Excel’s common functions every day – autosum, averages, count and minimum and maximum – all I have to do […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[220,225,302],"class_list":["post-679","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-excel-training-y","tag-excel-training-london-blog","tag-how-to-use-autosum"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=679"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/679\/revisions"}],"predecessor-version":[{"id":6727,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/679\/revisions\/6727"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}