Good evening, I ask you to help with a formula.
In J2 cell it is returned me by a formula reference to a cell.
I have to make a sum of B2: the reference that is in cell J2
how to write the formula?
Thank you.
Good evening, I ask you to help with a formula.
In J2 cell it is returned me by a formula reference to a cell.
I have to make a sum of B2: the reference that is in cell J2
how to write the formula?
Thank you.
Hi Berna11,
You will need to use the INDIRECT function.
=SUM(B2:INDIRECT(J2))
Regards,
Snook
OK, well thank you so much just what I was looking for
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks