conditional sum

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?
 
X

Xt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
SUM / COUNT formula 3
Fuction to return and evaluate fuction 1
Pivot table calculated field Count(field) / sum(field) 0
HowTo: detect a cell contains an ArrayFormula in vba? 1
Offset, Match Questiond 5
Mutiply in a range of cells ? 1
Return Range Based on Cell Value 2

Top