Hi guys, I hope you can help.
I have a spreadsheet with a list of names in column A1. in column B1 has a T-shirt quantity, and C1 has the size of the T-Shirt (S, M, L, XL, 2XL)
Is there a quick way of calculating how many of each size I need? The list in question is about 2500 rows down and has other garments within the list so it wouldn't be as simple as just sorting by size and highlighting the quantities. Ideally what I want is a summary on sheet 2 showing me the totals - if that makes sense?
Thanks
Bookmarks