I guess I misunderstood this statement................

Is there any other statement to add to the COUNT(C8:j8) to enable count two
or more items selected in a cell as one (1) please?

You have A1=2, B1=2,1 and C1=1

What do you want as a result in D1?

COUNT will give you 2 because it counts numbers only

COUNTA will give you 3 which seems to be what your starement above asks for.

Do you want to count B1 as two numbers giving you a return of 4 in D1?


Gord

On Thu, 18 Jun 2009 19:17:08 GMT, "dolpandotcom via OfficeKB.com"
<u52610@uwe wrote:

I agree with your explanation Gord and also appreciate your explanations, but
take for an example if have a sheet with column label as A, B, C, D with one
row of data as shown below::

A B
C D
2 2,1
1

If I want to count the numbers that exist on that row as COUNT(Ax:Cx) whrer x
is the row number. The result which will be placed in cell Dx will not be 3
simply because the cell Bx is taken as character probably. My humble question
is that "How do I use the COUNT function to accomplish the task or is ther
any other function that I can use?

Thanks.
Dolpan

Gord Dibben wrote:
=COUNTA(C8:J8) counts multiple entries in a cell as one.

Also......I would change If Target.Column = 3 Then to

If Not Application.Intersect(Target, Columns("C:H")) Is Nothing Then

Nothing wrong with your revision except it potentially includes columns past
H

Gord

Hi Gord,

[quoted text clipped - 30 lines]
Dolpandotcom
06/16/09