Mike

one option

=SUMPRODUCT(--((LEFT(A1:A5,8)="Impaired")+(LEFT(B1:B5,8)="Impair ed")0))

Cheers
JulieD


"Mike" wrote in message
...
Ok, I have been working through this for the last few hours to no avail.

I have 2 columns of data, driver1 and driver2.

Column 1 (driver1) contains the following (for example)
Row1 - Not Impaired
Row2 - Impaired - Tested
Row3 - Impaired - Not Tested
Row4 - Not Impaired
Row5 - Not Impaired

Column2 (driver2) contains the following.
Row1 - Impaired - Tested
Row2 - Impaired - Tested
Row3 - Not Impaired
Row4 - Not Impaired
Row5 - Impaired - Tested

Each row represents a crash report.

I need to determine the accidents that involved impaired drivers (tested
and
untested).

I want to compare the specific row of column1 to column2 to determine if 1
of the 2 drivers was impaired, then count the total.

In this example my output should be 4.

Any help would be appreciated.

Thanks.