I would like to create a formula which sums up cells from another worksheet. Easy enough. In my current worksheet I have =SUM(August!B1:B10). The other worksheet is the previous month, and my current worksheet is the current month.
But how do I change B10 in the formula above to B11, B12 based on a COUNT in the current sheet. Ie If count in my current worksheet = 12, then replace the B11 to B12. If count=14, then change the B10 to B14 and so on. Currently I do this manually, but sometimes I forget. I guess this is more like a SUM formula based on the result of a COUNT formula.
=sum(Aug!B1:B(the value of the =count cell))
Any ideas?
But how do I change B10 in the formula above to B11, B12 based on a COUNT in the current sheet. Ie If count in my current worksheet = 12, then replace the B11 to B12. If count=14, then change the B10 to B14 and so on. Currently I do this manually, but sometimes I forget. I guess this is more like a SUM formula based on the result of a COUNT formula.
=sum(Aug!B1:B(the value of the =count cell))
Any ideas?