Hi,

Looking for a bit of help! (obvs)

I have only 2 columns of data. Column A is all the industry segments our customers fall under. there are 330 sales but only 24 unique segments in total.

I want a sort of distribution table here: how many sales between 0 & 50 did each of the segments do. Then >50 & <=150, then >150 & <=250 and so forth.

I've done my coountif to total the number between these values, but I can't for the life of me get it to do the same but for each segment.

Not sure how to upload as yet, just new here.

Thanks,

H