conditional sum

  • Thread starter Thread starter Uffe Kousgaard
  • Start date Start date
U

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?
 
It is actually the sum of the values in those cells I am after. Otherwiseit
would be too easy.
Click to expand...

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