Count data

[John Palmer]

Hi,
I'm trying to get excel to count data entered into a
column. Data is enetered as a text reference (ie A1 up to
J10). I need to know how many entries there are. It would
be easy but some of the entries reflect activities
instead (ie "looking around"). Can anyone tell me how to
count the number of text references and to ignore the
entries which refer to an activity.

If it helps i already have the text references formatted
as a named cell range, elsewhere in the workbook.

Thanks

John

 

[CLR]

=counta(TextRangeName) will count all the cells with values in a range

=counta(TextRangeName)-count(TextRangeName) will count only the ones with
text.

You can always use a helper column to mark the desirable values to count,
then count that column.

hth
Vaya con Dios,
Chuck, CABGx3

 

[John Palmer]

Hi,

Thanks very much for that. Have now managed to achieve
the desired result.