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