Sorting/counting/summing by step Macro help.

hi TCDataAnalyst, welcome to Excelforum, it's always helpful to see an example worksheet with original data plus result you need to obtain.

Thanks for the feedback! Please let me know if there is anything else I could add to make my post more complete.

would still ask for explanation getting Count and Sum results as per gif file

I'm sorry for my vague posting and appreciate your piecing together my question for me. the list of data is packages and each one is the number of units in a package. The steps are by weight and the increment is the number of units per lb(Step). I need to sum the units for the packages in each weight range set and count them. and then total the columns. the units have to be less than or equal to the increment. for example 200 would be counted as a 200, but 201 might be counted as a 250.

Please let me know if you have any more questions!

thanks, the question on your post #1 example:
steps: 100, 200, 300
increment: 100
data: 100,101,200, 300
steps - 100, count - 1, sum - 100 - clear
steps - 200, count - 2, sum - 201 (100+101) - clear
steps - 300, count - 1, sum - 300 - Not clear, why does count equals 1 and sum 300?

I've been busy working on this, and through my work, I can better explain my objective.

I have a list of shipments that vary in size. I need to count the shipments and total the units per shipment by a pound/unit range. The Steps go from 1 to 10 and then in increments of 5 above 10. If a shipment has the exact amount of units in a step it is counted in that step, but if it's even one over, it is counted in the following step.

My first for statements creates the table and embedded in there is another for loop that cycles through the shipments to see add/count the values to the current step.

My code is sloppy because I'm pretty much going off logic and code pulled off the recorder.

Please Login or Register  to view this content.

The way i'm testing the shipment set is a little backwards, but it's the only way i could figure out right now. I'm currently getting an overflow error when I run the script.

These are just Sums and counts for a data set. there was only 1(count) value that fell between 200 and 300, and that value was 300 units(sum). Is that clear?

Re: overflow error
Change data type of LowEnd or Increment to Long instead of current Integer

Logic of your posted examples is still not clear. Your posted code produces zeroes for all Pounds except 1. Please provide calculations for each Pounds as if you count that manually with explanations of what and why you are doing.

as your post #11 attached gif is now viewable, I've modified the code to meet your output result and formatting. Some changes have been done to make it faster, please check attachment

formulas only option, amend ranges to suit your needs