How to count

[Tom67K]

Hi, need some help with below topic :

- in the template, the range B1:B12 - have some numbers

- want to summary on those columns , which are define by number , which is indeecated separatly

eg. B1- 2;B2-1;B3-5 ; in the other cell (eg.J1)have a formula's result eg.2 , so want to count only 2 cells - b1&b2; result in J1 can change to eg3 - so I want to calculate than all3 numbers from range B1:B3.

How to do that? Need help :)

[#2]

@Tom67K 

=SUM(INDIRECT("B1:B"&J1))

You can try this formula if you want to sum the ranges.

 

[#3]

@Tom67K 

A non-volatile formula that requires Excel 365

= SUM(TAKE(data, N))

where 'data' is $B$1:$B$15 and 'N' is $J$1.

[#4]

@OliverScheurich 

Have tried witha rows and failed :(

What should I change?

[#5 · Accepted solution]

@Tom67K 

=SUM($B$5:INDEX($B$5:$P$5,J1))

This formula returns the intended result in my sheet.

[#6]

@Tom67K 

For me it changes the formula to

= SUM(TAKE(data,1,N))

[#7]

I prefer that to the INDIRECT!

[#8]

@Peter Bartholomew 

Thanks , for your support.

[#9]

You are amazing, Thx !