Sum a column within a named range

  • Thread starter Thread starter Chris Kettenbach
  • Start date Start date
C

Chris Kettenbach

Hi All. If I have a named range in a worksheet, how do I sum a single
column of a multi column range? I know how to use vba to do this but what
would a logical excel formula be? I think I am on the right track.

I keep trying things like =sum(_NamedRange(B:B)) but that does not work. Is
this even possible? The desired result would have been to sum the 2nd column
of numbers in the _NameRange. Any help is appreciated. Thanks everyone.

~ck
 
Chris said:
Hi All. If I have a named range in a worksheet, how do I sum a single
column of a multi column range? I know how to use vba to do this but what
would a logical excel formula be? I think I am on the right track.

I keep trying things like =sum(_NamedRange(B:B)) but that does not work. Is
this even possible? The desired result would have been to sum the 2nd column
of numbers in the _NameRange. Any help is appreciated. Thanks everyone.

~ck
Click to expand...
=SUM(INDEX(_NameRange,0,2))

Alan Beban
 
Alan

I tried as you suggested. Didn't seem to work with the underscore prio
to the range name but did withoout the underscore.

What is the underscore supposed to represent anyhow?

Deepa
 
The original poster said "I keep trying things like
=sum(_NamedRange(B:B)) but that does not work." So I quite naturally
assumed that the underscore was part of the name of his subject range.
Whatever its name is, that's what goes in the formula.

Alan Beban
 
Back
Top