Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting of tickets that have certain criteria
Hi
I am currently working on producing reports from a data dump. One of the reports is based on counting how many incidents are there of a certain criteria. Easy enough except the criteria is across 4 columns (see below) SYSTEM COMPONENT ITEM MODULE LTN-ENVIRONMNT ENVIRONMENTAL PWR-DISCONNECT N/A LTN-NETWORK NETWORK-DEVICE UNKNOWN FAULTY-CARD How do I tell excel to count how many tickets there are of LTN-ENVIRONMNT, ENVIRONMENTAL, PWR-DISCONNECT, N/A (for example)? Basically one ticket would contain the 4 column information otherwise it wouldnt be valid. Thanks Nicki |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting of tickets that have certain criteria
Put you test values in M1:M4, and use
=SUMPRODUCT(--($A$2:$A$200=M1),--($B$2:$B$200=M2),--($C$2:$C$200=M3),--($D$2 :$D$200=M4)) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Nicki King" <Nicki wrote in message ... Hi I am currently working on producing reports from a data dump. One of the reports is based on counting how many incidents are there of a certain criteria. Easy enough except the criteria is across 4 columns (see below) SYSTEM COMPONENT ITEM MODULE LTN-ENVIRONMNT ENVIRONMENTAL PWR-DISCONNECT N/A LTN-NETWORK NETWORK-DEVICE UNKNOWN FAULTY-CARD How do I tell excel to count how many tickets there are of LTN-ENVIRONMNT, ENVIRONMENTAL, PWR-DISCONNECT, N/A (for example)? Basically one ticket would contain the 4 column information otherwise it wouldnt be valid. Thanks Nicki |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Using Multiple Criteria | Excel Worksheet Functions | |||
counting cells with two criteria | Excel Discussion (Misc queries) | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Counting the number of cells meeting conditional formating criteria | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions |