tag:blogger.com,1999:blog-1869924468172210809.post231157213802166288..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: Excel Tips - Quickly adding up numbers without formulaeGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1869924468172210809.post-35053325822495528162013-09-10T16:15:15.467+01:002013-09-10T16:15:15.467+01:00Surely highlighting is much faster than entering a...Surely highlighting is much faster than entering a TOTAL or SUBTOTAL formula.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-43752810285725252762013-09-09T00:42:29.822+01:002013-09-09T00:42:29.822+01:00Or.. forget highlighting.... and much faster,,, ...Or.. forget highlighting.... and much faster,,, <br /> <br /> "CONTROL + ="<br /> <br /> ... Works on TOTAL as well as SUBTOTAL functions in EXCEL 07, 10 & 13. <br />But... ensure that there are no "EMPTY" celled in the column. If empty cells exist, the calculation will stop there. NOT fatal ....EASY FIX... place cursor in last cell and scroll up to the first cell of the column being summed. The problem is cured.<br />Enjoy!<br /> Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-66406329078615582382013-09-03T18:43:34.361+01:002013-09-03T18:43:34.361+01:00I'm not sure I understand your distinction bet...I'm not sure I understand your distinction between numbers and figures. I certainly didn't mean to make one.Glen Feechanhttps://www.blogger.com/profile/15601120984639539346noreply@blogger.comtag:blogger.com,1999:blog-1869924468172210809.post-30774707466093698802013-09-03T17:40:14.452+01:002013-09-03T17:40:14.452+01:00Not sure why you restricted this feature only to n...Not sure why you restricted this feature only to numbers? <br /><br />It works just as well and is probably more useful with figures.Anonymousnoreply@blogger.com