Grouping Strings - Excel

[KNKN9]

Hi,

I have two columns in excel

SizeB SizeC
200-500 A
200-500 A
200-500 B
5000-6000 A

Is there a way I can count how many A's there are for 200-500, how many B there are for 200-500. So grouping the size column in excel.

Thanks.

 

[Kyle123]

Yes, you want a Pivot Table, with SizeB in the Rows field and count of SizeC in the Data field

 

[Legacy 143009]

=COUNTIFS(A:A,"200-500",B:B,"A")
or
=COUNTIFS(A:A,"200-500",B:B,"B")

 

[KNKN9]

Thanks for getting back to me.

A pivot doesn't work for me column B is not just A and B but different sentences that are repeated.

I have managed to get what I want now.

Thank you.

 

[KNKN9]

Thanks,

Not sure why countifs didn't cross my mind.

Much appreciated.

 

[Kyle123]

You do realise that in this scenario, countifs is exactly the same as a less flexible solution to a PT right?

Anyway, glad you dot it sorted!