analysis data into range
 

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

analysis data into range
 

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

"SYL" wrote:

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

analysis data into range
 

Try the FREQUENCY function.
--
David Biddulph

"SYL" wrote in message
...
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

analysis data into range
 

A1 = data being analyzed

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

"SYL" wrote:

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

analysis data into range
 

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

"Toppers" wrote:

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

"SYL" wrote:

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