microsoft_excel:sum_with_na_in_range
This is an old revision of the document!
Table of Contents
Microsoft Excel - 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 if errors in a range
=SUM(IF(ISERROR(A1:A6),1))
returns 2.
microsoft_excel/sum_with_na_in_range.1575996839.txt.gz ยท Last modified: 2020/07/15 09:30 (external edit)