Thread: subtotaling
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Morris Mike Morris is offline
external usenet poster
 
Posts: 2
Default subtotaling

PO# line no Description Quantity

555-00 2 11-4040-605NL 220
555-00 2 11-4040-605NL 100
555-00 2 11-4040-605NL 500
555-00 2 11-4040-605NL 20
555-00 3 11-4040-618 160
555-00 3 11-4040-618 100
555-00 3 11-4040-618 20
555-00 3 11-4040-618 20
555-00 3 11-4040-618 240
555-00 3 11-4040-618 20
555-00 3 11-4040-618 20
555-00 3 11-4040-618 40
555-00 3 11-4040-618 20
555-00 4 60-2517-618 400
555-00 4 60-2517-618 160
555-00 4 60-2517-618 80


I need to get subtotals for the amounts in the "quantity" column, where "po
#" and line #" are the same.