microsoft_excel:sum:sum_with_na_in_range
Table of Contents
Microsoft Excel - SUM - Sum with NA in range
Sample data:
1 2 #REF! 3 #REF! 5
Get the sum
=SUM(IFERROR(A1:D6,""))
returns 11.
Count the number of errors in a range
=SUM(IF(ISERROR(A1:A6),1))
returns 2.
microsoft_excel/sum/sum_with_na_in_range.txt · Last modified: 2021/08/04 15:32 by peter