Hello,
How do I define an array by using row and column numbers?
What I want to do is:
=product(array)
in which the starting and ending cell are defined by row/column numbers.
For example:
Row 1, Column 1 = Cell A1
Row 3, Column 5 = Cell E3
I want to calculate '=product(A1:E3)' without using the term A1:E3 but instead define A1 and E3 using Row/Columns numbers.
Thanks!
Bookmarks