locked
SUM of a column in a named range RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Using Excel 2007.  We have a process that loads table data from SQL into a named range in an Excel spreadsheet.  The amount of data is subject to change which is why we use named ranges.  For our purposes say the named range is A5:DJ119.  How would I go about obtaining the SUM of column C, but only including values in that column which fall in the named range's rows?

    Thanks.

    Wednesday, March 11, 2015 11:10 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    You can use the range intersection operator (space):

    =SUM(MyNamedRange C:C)


    • Edited by Mark18991230 Thursday, March 12, 2015 9:07 PM
    • Proposed as answer by ryguy72 Friday, March 13, 2015 2:28 AM
    • Marked as answer by Caillen Monday, March 23, 2015 10:05 AM
    Thursday, March 12, 2015 9:04 PM