count cells

Hi

I need to count the numers in cells AI6:AI46 but some of these cells contain #DiV0! as the formlars in these cells do not have actual numbers as no data has been gathered (correct)

Can anyone help please

If you want to count the numbers in those cells,

try this:

Please Login or Register  to view this content.

If you want to count all non-blank, non-error values:

Please Login or Register  to view this content.

The COUNT function ignores text and errors.
The COUNTA function ignores errors.

Does that help?
or do you have a different issue?

the cells contain numbers in some from formulas in them e.g.
A
2
3
5
0
1
#Div0!
0
1
#Div0!

so I want all the numbered cells to be counted- in this case should add up to 12

Thanks

We must be having a terminology issue.
To me, you count numbers by determining how many numbers exist.
In the below values...there are 2 numbers.
Alpha
5
10
Bravo

If you mean something else, please clarify.
And...post the formula you are using (even if it doesn't work).

Please read the forum rules below and the 2 x messages I've sent you then add the links to the cross posts or this thread will be closed for breaking the rules & ignoring a mod

VBA Noob

http://www.cleveregg.co.uk/forum/forumdisplay.php?f=12

Ok...I understand...
you don't want to "count" the numbers....
you want to exclude error cells from the sum.

Try one of these....

If the only errors will be DIV/0, then

Please Login or Register  to view this content.

But, if there may be other errors (eg #N/A, etc), then
use this ARRAY FORMULA, committed with CTRL+SHIFT+ENTER
(instead of just ENTER):

Please Login or Register  to view this content.

oh thanks gonna give that a try now

wow that worked a treat

Thanks loads