I want to sum up a range of cells but have the number of cells be a variable defined by another cell. It would be nice if the following worked, for example
=sum(b18:b(18-a18)), but it doesn't. This would sum up all the cells from b18 back for a18 cells
=sum(b18:b(18-a18)), but it doesn't. This would sum up all the cells from b18 back for a18 cells