Excel formula
 

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

Excel formula
 

maybe...
=countif(b3:af3,"s=2")
or
=countif(b3:af3,"*"&"s=2"&"*")
if s=2 can be in a cell with other text.



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

--

Dave Peterson

Excel formula
 

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