Examples
In the worksheet shown, the formula in H5, copied down, is: Notice that SUMSQ automatically ignores empty cells and text values.
Notes
Arguments can be a mix of constants, names, arrays, or references that contain numbers. Empty cells, logical values, and text values are ignored when they appear in arrays or references. The logical values TRUE and FALSE are evaluated as 1 and 0 respectively, but only when they are hardcoded as arguments. Numbers entered as text (i.e. “1”, “3”, etc.) are evaluated, but only when they are hardcoded as arguments.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
