+ Reply to Thread
Results 1 to 2 of 2

Cell selection - starting from another cell other than the initial cell

  1. #1
    Registered User
    Join Date
    04-16-2014
    Location
    SF
    MS-Off Ver
    Excel 2013
    Posts
    1

    Cell selection - starting from another cell other than the initial cell

    Hi everyone, I have a cell selection question hopefully someone can answer

    Let's say I'm at the bottom of a bunch of cells that have values with rows in between

    I want to add up the cells (not a sum function - maybe there are other numbers between the values I want to add)

    So in the total cell you hit "=" then keyboard up to the first number you want to sum, then you hit "+"

    But here's the problem - the selection cell starts at the total cell and then you have to spend a bunch of time to keyboard up past the initial selection to the next value, hit "+", then start all the way over at the total cell and do it again, etc.

    I'm convinced I remember someone using an arrow key combination such that instead of starting all the way back at the total cell after hitting "+", you'd instead start at the last value you added

    (e.g. Total cell is C30, instead of starting there you start at cell C10, which is the cell you just selected after hitting "+")

    Does this make sense? Am I hallucinating this ability or what?

    Many thanks

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Cell selection - starting from another cell other than the initial cell

    I didn't know if there is one, so I checked Chip Pearson's helpful shortcut table, and I couldn't find what you're referring to.

    ...Well, if I was in your boat, I would create a helper column adjacent to the data for "add this row yes/no" and then push the helper column and the summation column into a SUMPRODUCT or SUMIF, and not have to change the formula after that, only the helper column.

+ 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. Replies: 0
    Last Post: 03-20-2014, 10:57 AM
  2. copy a cell multiple times depending on cell value starting on a specific cell
    By weritadiojomiel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2013, 05:25 AM
  3. [SOLVED] if true then copy initial cell to new cell
    By 4430salton in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-09-2012, 12:29 PM
  4. Replies: 2
    Last Post: 07-15-2009, 08:43 AM
  5. [SOLVED] Macro for cell selection starting with Last Cell
    By Valerie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-09-2005, 04:30 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