a SUM formula based on a COUNT value

[xljruser]

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?

 

[VoG]

Try

=sum(Aug!B1:B&INDIRECT(count cell address))

 

[barry houdini]

If your count is in cell H2..

=SUM(August!B1:INDEX(August!B:B,H2))

 

[xljruser]

thanks guys. Got it to work.

thanks