2

I can easily count number of #N/A's in a column with the array formula:

=SUM(--ISNA(A:A))

enter image description here

How would I count the number of #DIV/0!'s in a column ??

1 Answer 1

2

You could =COUNTIF(A3:A10,"#DIV/0!")

Source: http://www.excel-easy.com/examples/count-errors.html

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .