It seems like the COUNT function would do what you want. It only counts
numeric cells.

Example:
=COUNT('myworksheet'!$A2:$A500)
that will only count the numeric cells in $A2:$A500 on myworksheet

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"cestbarb" wrote:

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.