microsoft_excel:count:count_the_number_of_errors_in_a_range
Microsoft Excel - Count - 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/count_the_number_of_errors_in_a_range.txt · Last modified: 2021/08/04 13:52 by peter