conditional sum

[Uffe Kousgaard]

I would like to count the cells from A1 to Ax, hvor x is a number I read in
another cell.

Something like a calculated range. Which formula does that?

 

[Uffe Kousgaard]

I would like to count

It is actually the sum of the values in those cells I am after. Otherwise it
would be too easy.

 

[Xt]

It is actually the sum of the values in those cells I am after. Otherwiseit
would be too easy.

Let's say the x number is in B1 then try =SUM(INDIRECT("A1:A"&B1))
xt