Subtotal

  • Thread starter Thread starter Gallego
  • Start date Start date
G

Gallego

Here's my scenario. I have several status codes besides the example below.
I want to put a counter on a spreadsheet that adds the qty for each code. so
for MT the sum of items in that code is 5. what is the formula?
Qty Status
2 MT
1 MT
1 MT
2 MT
 
You can put your unique list of codes in D1 and below, for example,
then in E1 you can use this formula:

=SUMIF(B:B,D1,A:A)

and then copy this down as required.

Hope this helps.

Pete
 
The OP emailed his sheet directly to me last night (without
asking !!), so I put the formula in there and sent it back to him.

Pete
 
Back
Top