analysis data into range

[Guest]

Any one know how to convert data into range?

Like
A 18
B 25
C 120

Then
Range 0-100: 43 (i.e. A+B)
Range 100-200: 120 (i.e.C)

There are more than 8 range, therefore if function might not work effectively

 

[Guest]

What you expect the results to be with following data (as there several
cobinationns of A to D < 100)?


A 18
B 25
C 37
D 40
E 120

 

[David Biddulph]

Try the FREQUENCY function.

 

[Guest]

A1 = data being analyzed

=CEILING(A1,100)-100&" - "&CEILING(A1,100)

 

[Guest]

I expect to see sum of A,B,C & D. Ie those btw 0-100