Count cells with numbers and ignore cells with errors
You can simply use
=SUMPRODUCT(--ISNUMBER(A1:A20))
as the ISNUMBER ignores text and errors
--
---
HTH
Bob
(change the xxxx to gmail if mailing direct)
"WonderingaboutMicrosoft"
wrote in message
...
I want to count the cells with numeric values and ignore the cells that
contain #DIV/0! in Office 2007 Beta BTR.
I have tried countif, countifs, and several other formulas. I have tried
setting the cells to TRUE and FALSE and counting numeric values but
nothing
seems to work.
Thanks in advance.
|