Hi

When SUMPRODUCT returns results, it defaults to TRUEs and FALSEs. The double
minus coerces the results to be 1s and 0s. A good explanation can be read
he
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Read the FORMAT OF SUMPRODUCT section about halfway through.

Andy.

"Nuraq" wrote in message
...
Andy,

What is the purpose of the "--" before the ISNUMBER?

<Andy wrote in message ...
I missed your worksheet ref:
=SUMPRODUCT(--(ISNUMBER(myworksheet!A2:A500)))


<Andy wrote in message ...
Hi

Try this:
=SUMPRODUCT(--(ISNUMBER(A2:A500)))

Andy.

"cestbarb" wrote in message
...
I'll try to make this simple -
I have a large spreadsheet and I need to calculate how many occurrences
of a
statement, however I want to exclude from the count if a column
contains an
alpha character.
Example - a spreadsheet contains numbers in the first column (which I
want
to count) and also alphanumeric (which I want to exclude). How do I
make up
the formula. To further complicate matters I'm doing the calculations
on
another worksheet. So far I have COUNTIF'myworksheet'!$A2-$A500 --
here I
want to say count if it contains only a number --
Is this clear?
Thanks.