counting

  • Thread starter Thread starter pierre
  • Start date Start date
P

pierre

hello
i have cells from A1:A3 and A6:A10 which contain text strings.
now what should be the formula if i want to count these cells ? (answer
should be 8)

what should also be the formula change if the cells would contain numbers ?
 
Hmm,

Is this homework, we don't normally do that here we point people in the
right direction.

Look in Excel help for

COUNTA
COUNT

and you should be able to work it out.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
=counta(a1:a3,a6:a10)
will count the cells that have anything in them -- numbers, text, even formulas
that evaluat to "".

=count(a1:a3,a6:a10)
will count the cells that only have numbers in them.
 
Back
Top