countifs or sumif?

I am tracking items taken from inventory. At any given time we take out tshirts and distribute to branches.  I need to provide totals of all sizes distributed per branch. I started using a countif..example countifs(a1:a100,”s”, B1:b100,”2″) although helpful it only gave me a count of single entries. So basically i would have to enter one at a time and that would take a lot of space. So I am trying to figure out how i can be Excel to not just count all the sizes but to return a number in any given size per branch. Normally I receive a call to send 200 tshirts to a branch. they would be of all difference sizes. I would ultimately like to enter the quanitties of smalls, larges, xlarges, etc. and have a running total at the bottom for each size.


Leave a Reply

Your email address will not be published. Required fields are marked *