Countif Newbie help

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

I'm hoping this attachment works!

Hi,

Basically I want to know using a formula, how many sales between £0 & £50 the Bakers, Bus Operator etc made.
Then the same for £50+ & £150, then 151+ & £250. In the £0-£50 bracket, Bakers would be 0

i'm not really sure what it is you want here. I thought I had come to a forum for help and explained my needs fairly well.

Mock up the results? Can anyone else understand my needs based on my post and data?

Thanks

Hi,

Added a few totals to the sheet.

Thanks,

Heather

Perfect!

Thank you so much for all the help

Thanks,

Yes already did the star - will close off the thread.

H