23 Ağustos 2015 Pazar

Count Number of Errors


Making too much calculation cause some Excel errors. So you can count these errors on your table.
=SUM(--ISERR(D2:D10))
Also number of lines that includes no error.
=SUM(--NOT(ISERR(D2:D10)))
Typical screenshot:





Hiç yorum yok:

Yorum Gönder