A
Anna B
Hi,
I would like to be able to, in a single cell, sum a number of looked
up values. One way, of course, would be to make a long formula where
the only change between plus-signs is which cell to concatenate with
cell E2
=lookup($A$2 & $E10 ;data; $H$25)+lookup($A$3 & $E10 ;data; $H$25)+...
Instead I tried the following
{=sum(lookup(A2:A7 & E10;...)}
with the result that only the lookup based on the first cell of the
range & E10 was returned and summed, not the A3 & E10 etc.
Is it possible, if so how, to use some sort of array formula where you
specify a range to be concatenated, one at a time, with the particular
cell, in this case E10? Or is there some other simple solution? (I
suppose A2:A7 & E10:E15 might work, but I'd rather not use more cells
than needed in the worksheet).
Thanks in advance,
Anna
I would like to be able to, in a single cell, sum a number of looked
up values. One way, of course, would be to make a long formula where
the only change between plus-signs is which cell to concatenate with
cell E2
=lookup($A$2 & $E10 ;data; $H$25)+lookup($A$3 & $E10 ;data; $H$25)+...
Instead I tried the following
{=sum(lookup(A2:A7 & E10;...)}
with the result that only the lookup based on the first cell of the
range & E10 was returned and summed, not the A3 & E10 etc.
Is it possible, if so how, to use some sort of array formula where you
specify a range to be concatenated, one at a time, with the particular
cell, in this case E10? Or is there some other simple solution? (I
suppose A2:A7 & E10:E15 might work, but I'd rather not use more cells
than needed in the worksheet).
Thanks in advance,
Anna