Cumulative totals of sub-sets of figures

J

jamesl

I have a column of numbers:

0.82 0.93 1.23 2.53 8.53 etc

I would like to know what the cumulative totals are for ranges of thos
numbers: 0.8-1.0 1.0-1.2 1.2-1.4 and so on.

Is there are a way of doing this automatically, or do I have to coun
them up?

thanks for any replies
 
P

Peo Sjoblom

Not very elegant perhaps but this might do what you want

=SUMPRODUCT(--($A$1:$A$500>=ROW(4:4)/5),--($A$1:$A$500<=ROW(5:5)/5),$A$1:$A$
500)

will increase criteria with 0.2 for each row you copy it down staring with
0.8 and 1.0, change the equal signs if you don't
want to include the higher criteria

=SUMPRODUCT(--($A$1:$A$500>=ROW(4:4)/5),--($A$1:$A$500<ROW(5:5)/5),$A$1:$A$5
00)



--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
J

jamesl

I've just discovered that you can do it with an array function calle
FREQUENCY which seem to do the job.

Thanks for your help
 
Top