microsoft_excel:sum_with_na_in_range
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| microsoft_excel:sum_with_na_in_range [2019/12/10 16:53] – created peter | 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 if errors in a range ===== | ||
| - | |||
| - | < | ||
| - | =SUM(IF(ISERROR(A1: | ||
| - | </ | ||
| - | |||
| - | returns 2. | ||
microsoft_excel/sum_with_na_in_range.1575996839.txt.gz · Last modified: 2020/07/15 09:30 (external edit)