Sum a column within a named range

[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

 

[Alan Beban]

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

=SUM(INDEX(_NameRange,0,2))

Alan Beban

 

[agarwaldvk]

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

 

[Alan Beban]

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