Hi everybody
I am looking for a way to use the sum function with named range
intersection. Here is my thinking.

I have data in columns and rows. I would like to create a named range
for the columns to be added together(ColumnsToAdd). Then I insert a
sum function which would add the columns in the current row.

Say ColumnsToAdd refers to columns B to D. The named range
ColumnsToAdd refers to those columns(B:D). In column E, I put the sum
function similar to this: = sum(ColumnsToAdd Intersect CurrentRow ).

I would like the sum formula to evaluate the intersection between my
named range and current row to compute the correct total for each of
the 10 rows. Is this possible somehow ?

TIA
Van

Try something like this:

E3: =SUM(ColumnsToAdd 3:3)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

Hi everybody
I am looking for a way to use the sum function with named range
intersection. Here is my thinking.

I have data in columns and rows. I would like to create a named range
for the columns to be added together(ColumnsToAdd). Then I insert a
sum function which would add the columns in the current row.

Say ColumnsToAdd refers to columns B to D. The named range
ColumnsToAdd refers to those columns(B:D). In column E, I put the sum
function similar to this: = sum(ColumnsToAdd Intersect CurrentRow ).

I would like the sum formula to evaluate the intersection between my
named range and current row to compute the correct total for each of
the 10 rows. Is this possible somehow ?

TIA
Van

Yes, it worked wonderfully. I will try to find more info about this
syntax since I had missed entirely this type of cell specification in
documentation. Thanks again

Van

On Jul 8, 11:12 am, Ron Coderre
wrote:
Try something like this:

E3: =SUM(ColumnsToAdd 3:3)

Does that help?
***********
Regards,
Ron

XL2002, WinXP



" wrote:
Hi everybody
I am looking for a way to use the sum function with named range
intersection. Here is my thinking.

I have data in columns and rows. I would like to create a named range
for the columns to be added together(ColumnsToAdd). Then I insert a
sum function which would add the columns in the current row.

Say ColumnsToAdd refers to columns B to D. The named range
ColumnsToAdd refers to those columns(B:D). In column E, I put the sum
function similar to this: = sum(ColumnsToAdd Intersect CurrentRow ).

I would like the sum formula to evaluate the intersection between my
named range and current row to compute the correct total for each of
the 10 rows. Is this possible somehow ?

TIA
Van- Hide quoted text -

- Show quoted text -

I'm glad that worked for you.....thanks for letting me know.


***********
Regards,
Ron

XL2002, WinXP


" wrote:

Yes, it worked wonderfully. I will try to find more info about this
syntax since I had missed entirely this type of cell specification in
documentation. Thanks again

Van

On Jul 8, 11:12 am, Ron Coderre
wrote:
Try something like this:

E3: =SUM(ColumnsToAdd 3:3)

Does that help?
***********
Regards,
Ron

XL2002, WinXP



" wrote:
Hi everybody
I am looking for a way to use the sum function with named range
intersection. Here is my thinking.

I have data in columns and rows. I would like to create a named range
for the columns to be added together(ColumnsToAdd). Then I insert a
sum function which would add the columns in the current row.

Say ColumnsToAdd refers to columns B to D. The named range
ColumnsToAdd refers to those columns(B:D). In column E, I put the sum
function similar to this: = sum(ColumnsToAdd Intersect CurrentRow ).

I would like the sum formula to evaluate the intersection between my
named range and current row to compute the correct total for each of
the 10 rows. Is this possible somehow ?

TIA
Van- Hide quoted text -

- Show quoted text -