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