I'm trying to do a subtotal count.
Can I get a count of the number of red shirts, yellow shirts, green shirts, red pants, green pants, etc.? I know I can use countif item=shirt, and color=red, etc. But my actual sheet I'm working with has a very long list of items so writing a formula for each item would be too tedious. Is there a way to do a subtotal by item? Or write the formula so it calculates the subtotal every time the item changes?
Help Article Resources
Check out the Formula Handbook template!