+ Reply to Thread
Results 1 to 3 of 3

Keystrokes involved when using the "sum" forumula

  1. #1
    Registered User
    Join Date
    08-14-2015
    Location
    Philadelphia, PA
    MS-Off Ver
    Office 365 for Windows
    Posts
    18

    Keystrokes involved when using the "sum" forumula

    Excel Windows for Office 365

    I click on a cell
    1. type =sum(
    2. I click on the first cell
    3. I type :
    4. I click on the last cell of that cells that I want to be summed up

    When I click on the 2nd cell, Excel erases part of what I already have entered. For example "A1:" gets replaced with A20.

    What's the most efficient keystrokes to use, given that you want to select the cells instead of typing the cell references?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,425

    Re: Keystrokes involved when using the "sum" forumula

    What you describe should work.

    Alternatively, you can select cells A1 down to A21 and click on the AutoSum icon on the ribbon.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Keystrokes involved when using the "sum" forumula

    Also

    After entering =sum(
    click on first cell
    while holding down the Shift key click the last cell
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  2. [SOLVED] Forumula to assign "score" based on Cell Value
    By Kurozyl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-05-2016, 08:14 AM
  3. Forumula to put 3 "spaced" numbers from one cell, into three separate cells.
    By richard11153 in forum Excel Formulas & Functions
    Replies: 30
    Last Post: 01-14-2014, 02:23 AM
  4. [SOLVED] Returning specific characters in a workbook name and changing is there is "_" involved
    By jshaw82 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-06-2013, 12:08 PM
  5. Conditional formatting with a " - -" involved
    By davidingilbert in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2013, 05:47 PM
  6. NEED ADVICE- 3 IF funtions with OR funtion in forumula, "Almost"
    By Jlf in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-21-2012, 07:52 AM
  7. [SOLVED] How to quote cells when "IF" word is involved
    By Ming in forum Excel General
    Replies: 6
    Last Post: 08-12-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1