PC Review


Reply
Thread Tools Rate Thread

conditional sum

 
 
Uffe Kousgaard
Guest
Posts: n/a
 
      7th Oct 2011
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?


 
Reply With Quote
 
 
 
 
Uffe Kousgaard
Guest
Posts: n/a
 
      7th Oct 2011
"Uffe Kousgaard" <(E-Mail Removed)> wrote in message
news:4e8eac4e$0$293$(E-Mail Removed)...
>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.


 
Reply With Quote
 
Xt
Guest
Posts: n/a
 
      7th Oct 2011
On Oct 7, 8:43*pm, "Uffe Kousgaard" <o...@no.no> wrote:
> "Uffe Kousgaard" <o...@no.no> wrote in message
>
> news:4e8eac4e$0$293$(E-Mail Removed)...
>
> >I would like to count

>
> 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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:01 PM.