microsoft_excel:count_the_number_of_errors_in_a_range
This is an old revision of the document!
Microsoft Excel - Count the number of errors in a range
Sample data:
1 2 #REF! 3 #REF! 5
Count the number of errors in a range
=SUM(IF(ISERROR(A1:A6),1))
returns 2.
microsoft_excel/count_the_number_of_errors_in_a_range.1575997005.txt.gz ยท Last modified: 2020/07/15 09:30 (external edit)