counting
 

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 ?

counting
 

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.


"pierre" wrote:

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 ?

counting
 

=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.



pierre wrote:

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 ?

--

Dave Peterson