Limit a sum within a named range

[Stu Dapples]

If I have a range defined as he whole width of a sheet, is it possible, on another sheet, to use a formula to say I want the sum of all the cells in column E, within the defined range?

The range is set up to capture all the data input for a week (7 days) by the width of the sheet (about 45 columns), what I am trying to do is say that the sum total of the specified column within the named range....

Hope that maks sense!

 

[pgc01]

Hi

This formula sums column 3 in the named range MyRng:

=SUM(INDEX(MyRng,0,3))

 

[mikerickson]

How about
=SUMPRODUCT(--(COLUMN(namedRange)=3)*namedRange)