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