microsoft_excel:sum_with_na_in_range
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| microsoft_excel:sum_with_na_in_range [2020/07/15 09:30] – external edit 127.0.0.1 | microsoft_excel:sum_with_na_in_range [2021/08/04 14:32] (current) – removed peter | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== Microsoft Excel - Sum with NA in range ====== | ||
| - | |||
| - | Sample data: | ||
| - | |||
| - | < | ||
| - | 1 | ||
| - | 2 | ||
| - | #REF! | ||
| - | 3 | ||
| - | #REF! | ||
| - | 5 | ||
| - | </ | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ===== Get the sum ===== | ||
| - | |||
| - | < | ||
| - | =SUM(IFERROR(A1: | ||
| - | </ | ||
| - | |||
| - | returns 11. | ||
| - | |||
| - | ---- | ||
| - | |||
| - | ===== Count the number of errors in a range ===== | ||
| - | |||
| - | < | ||
| - | =SUM(IF(ISERROR(A1: | ||
| - | </ | ||
| - | |||
| - | returns 2. | ||
microsoft_excel/sum_with_na_in_range.1594805433.txt.gz · Last modified: 2020/07/15 09:30 by 127.0.0.1