Hi,
From the list of data below whereby company type A ordered 5, 9, 33, 66 and 72 units, Type B ordered 21 units, Type C ordered 38, 39, 95 and 98 units,
Capture1.JPG
What formula do I need in the table below to bring up the results for each range of 10 units currently manually keyed there please ?
i.e Range 0 to 10, Type A made 2 orders in this range. What is the formula to bring up the result of 2?
and I would like to extrapolate that formula to fill the Table between cells K2 and M11
Thank You
Wanted Results:
Capture2.JPG
Bookmarks