| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells with a particular type formatting | Excel Discussion (Misc queries) | |||
| Getting the top five incidents | Excel Worksheet Functions | |||
| Counting&Sorting multiple serial numbers per machine type | Excel Discussion (Misc queries) | |||
| Counting number of incidents of a month | Excel Worksheet Functions | |||
| filter errors depending on number of incidents | Excel Discussion (Misc queries) | |||
Threaded Mode
