Sum Values in a Range While Ignoring #N/A


For this example, let’s take a range that has both #N/A values and numeric values.  Using the following formula, we can exclude all #N/A’s from being included in the sum:
=sumif(A1:A10,”<>#N/A”)
This formula will sum all values in the first column between rows 1-10 that does not contain #N/A.  There are many other instances where the sumif formula can be used that makes summing large ranges possible.  We will explore these as well as the CTRL+SHIFT+ENTER formulas, that provide even more functionality.

Popular posts from this blog

Comments