Thread: Subtotal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gallego Gallego is offline
external usenet poster
 
Posts: 10
Default Subtotal

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