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

MiaP

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?

Find more posts tagged with

Formulas

help

Accepted answers

All comments

Michelle Choate 2

Can you provide a screenshot of your sheet?

Paul Newcome

Are you able to provide screenshots for context?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.