Eduardo,

Yes the numbers and ILL are on the same row, actually in the same cell.
Cell A1 = ILL 8 and Cell B1=ILL 6.2 and so on for the whole month. I am
trying to get all cells in the row totaled.

Thanks

Sam

"Eduardo" wrote:

Hi,
is ILL and the numbers in one row??

"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?