+ Reply to Thread
Results 1 to 5 of 5

Sum specific number of cells in one column

  1. #1
    Registered User
    Join Date
    03-20-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    69

    Smile Sum specific number of cells in one column

    Hi there

    Can someone help me to build a formula to sum an exemple like this:

    The column goes from "A10 to A20" and i have the cell "D10" to imput a value to say that it will allways start in A10 but to end the "SUM" in the number defined by me, like sometimes it can sum only fromA1 to A3 or A1 "to the number that i imput on the cell" "D10" and have the result for exemple in cell D15.

    Example:
    If cell D10 have the value 5 SUM from A10 to A15.
    If the number from cell D10 changes to 7 and SUM changes from A10 to A17.

    Thank you so much.
    Armando
    Last edited by Blue_Wings; 02-28-2015 at 09:37 AM.

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Sum specific number of cells in one column

    Using your posted example, this formula sums from A10 through the number of cells indicated by D10
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    03-20-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    69

    Re: Sum specific number of cells in one column

    Quote Originally Posted by Ron Coderre View Post
    Using your posted example, this formula sums from A10 through the number of cells indicated by D10
    Please Login or Register  to view this content.
    Is that something you can work with?
    Its perfect!

    Thank you Ron Coderre

  4. #4
    Registered User
    Join Date
    03-20-2010
    Location
    Portugal
    MS-Off Ver
    Excel 2019
    Posts
    69

    Re: Sum specific number of cells in one column

    I was wondering... its possible to fill the cells with color?
    Example:
    If D10 have the value "2" then the cell A10 to A12 will be filled with color.

    I´ve tried to use the Conditional Formation with formula but i couldn't do it.

    Thank you.

  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,603

    Re: Sum specific number of cells in one column

    As this is an entirely new question please start a new thread perhaps with a link to this one - Thx

+ 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] I want to collect the cells in one column which begins with specific number
    By atakantekel in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 12-13-2014, 04:20 PM
  2. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  3. [SOLVED] Formula to count number of blank cells for a specific condition in another column
    By Daniel_12 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2013, 07:16 AM
  4. Sum of 2 cells in a column equal a specific number
    By philippe1 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-14-2011, 01:43 AM
  5. Counting number of populated cells in a specific column
    By SHS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2009, 02:37 PM

Tags for this Thread

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