Re: count cells wityh text?
- From: "Alan" <alan111@xxxxxxxxxxxx>
- Date: Mon, 7 Nov 2005 18:39:36 -0000
Hi Bob,
Cant understand how that works. Shouldn't it be:
=COUNTA(Sheet2!B1:B90)?
=COUNTA('!sheet2!'B1:B90) gives me a error.
Silvabod says it works! I'm at a loss, can you enlighten me please?
Regards,
Alan.
"Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23lrvs574FHA.472@xxxxxxxxxxxxxxxxxxxxxxx
> You could try
>
> =COUNTA('!sheet2!'B1:B90)
>
> which will count numbers as well. If you want to out-count these, use
>
> =COUNTA('!sheet2!'B1:B90)-COUNT('!sheet2!'B1:B90)
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Silvabod" <nospam@xxxxxxxxx> wrote in message
> news:3NLbf.5277$mF5.4506@xxxxxxxxxxxxxxxxxxxxxxx
>> Need to count the number of filled (text)cells in a column on a different
>> sheet.
>>
>> Tried =countif('!sheet2!'B1:B90<>"" but got syntax error. Despite the
>> "fx helper", can't get the syntax right.
>> It should return 59 (there are 59 names currently in the range).
>>
>> I range-named B1:B90 as "names" thinking that might help - no. What's
>> the
>> correct way to count "text" cells, in a named range, please?
>>
>>
>>
>
>
.
- Follow-Ups:
- Re: count cells wityh text?
- From: Harlan Grove
- Re: count cells wityh text?
- References:
- count cells wityh text?
- From: Silvabod
- Re: count cells wityh text?
- From: Bob Phillips
- count cells wityh text?
- Prev by Date: How to change the font/font size in a combo box
- Next by Date: Format change
- Previous by thread: Re: count cells wityh text?
- Next by thread: Re: count cells wityh text?
- Index(es):
Relevant Pages
|
