View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike G Mike G is offline
external usenet poster
 
Posts: 26
Default Counting type of incidents

I have a continuing list of "incidents". They are classified as type A or
B or C or D. I can "countif" the type and get totals of each, but what I am
having trouble with is whether or not not they have been resolved or still
open. The next column will have a text type answer in it if resolved and
left blank if not. The result will be somthing like : Type A has 40
incidents and 25 have been resolved. TIA for any suggestions