=sumproduct((a2:f2="ill")*(a2:f2<=8)*a2:f2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sam G" <Sam wrote in message
...
I am trying to create a formula to sum across a row with the following:

If any of the cells contain the text "ILL" and the number value is equal
to
8 or less than 8 sum. Any ideas?