Rick,

You need to clarify this (well for me you do). What precisely is in these
cells, is it a text string s=5 etc or something else?
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rick" wrote:

Range is b3:af3 I want to total entries that would have s=2 in a cell or s=5
in the range. I cannot get the formula to work .. Any suggestions