Hi,
How do I return an offset value within a named range using a formula?
For example, my range "RngTest" is from C3:J43.
If a value of "Product123" is found within the range, (lets say its found
in cells C3; E5 and E7), I need the accumulative values in the cells 'below'
(in cells D3; F5 and F7) added (SUM) and returned to cell L3.
Therefore if Cells D3; F5; and F7 have the respective values of 3; 4 and 5,
the value of cell L3 should be 12.
Also, do I need to express "RngTest" or "C3:J43" or does it matter?
Thanks in advance,
Neal