Which formula should i use to tally up the total amount of t-shirt sizes?

MiaP

Which formula should i use to tally up the total amount of t-shirt sizes?

I've tried different variations of sumif and countif but i cant seem to figure it out.

For example: My column name is Quantity/sizing with all of these different size quantities:

XS - 4 (I want another column with a shirt sizes calculated Total:

Small - 5

Medium - 8

Large - 6

XL - 13

XXL - 10

3XL - 5

4XL - 5

Can anyone help with this?

Michelle Choate 2

Can you provide a screenshot of your sheet?

Paul Newcome

Are you able to provide screenshots for context?