Thread: How do I insert a filtered subtotal into overall summary
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default How do I insert a filtered subtotal into overall summary
Use COUNTIF, e.g.:

=COUNTIF(A2:A100,"offloading")
=COUNTIF(A2:A100,"en route")

Or, if you put the word in a separate cell, eg C1, then:

=COUNTIF(A2:A100,C1)

I've assumed the data is in A1 to A100 - adjust cell references to
suit.

Hope this helps.

Pete

Reply With QuoteReply With Quote