software

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-CARDHow 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

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)

quot;Nicki Kingquot; lt;Nicki gt; wrote in message
...
gt; Hi
gt;
gt; I am currently working on producing reports from a data dump. One of the
gt; reports is based on counting how many incidents are there of a certain
gt; criteria. Easy enough except the criteria is across 4 columns (see below)
gt;
gt; SYSTEM COMPONENT ITEM MODULE
gt; LTN-ENVIRONMNT ENVIRONMENTAL PWR-DISCONNECT N/A
gt; LTN-NETWORK NETWORK-DEVICE UNKNOWN FAULTY-CARD
gt;
gt;
gt; How do I tell excel to count how many tickets there are of LTN-ENVIRONMNT,
gt; ENVIRONMENTAL, PWR-DISCONNECT, N/A (for example)? Basically one ticket
gt; would contain the 4 column information otherwise it wouldnt be valid.
gt;
gt; Thanks
gt; Nicki