I would like to know if it is possible to reference a cell in Excel depending on the value of another cell.
I have a cell, let's say
A1where I have the row number that I want to use (e.g., the content of
I want to compute the sum of column
1to the row corresponding to the number given in
A1. Something like
=SUM( B1:B<NUMBER_IN_A1> )
Is there any way?