If you're using Excel 2007, the SUMIFS function is what you want.

If row 1 has the text values to check, and row 2 has the values to sum (and
to check if they're less than or equal to 8), the formula would be
=SUMIFS(2:2,2:2,"<=8",1:1,"*ILL*")

--
Rob Jordan
Powered by Creative Laziness


"Sam G" wrote:

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?