Jimar,

With a macro perhaps:-

Sub liminal()
Dim myRange As Range
lastrowcola = Range("A65536").End(xlUp).Row
Set myRange = Range("A1:A" & lastrowcola)
For Each c In myRange
c.Select
If c.Value = "PPAO" Then
If ActiveCell.Offset(0, 1).Value = 1 _
Or ActiveCell.Offset(0, 2).Value = 1 _
Or ActiveCell.Offset(0, 3).Value = 1 Then
Count = Count + 1
End If
End If
Next
Range("E5").Value = Count
End Sub

Mike

"jimar" wrote:

I have an input sheet which contains the data and a summary sheet. I need to
put a formula in the summary sheet to count the number of rows in which the
following may occur "PPAO" is in Column A and the number 1 is in either
columns B or C or D.
Any help appreciated.