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.