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
|