Excel: How to Sum Values in a Column with N/A or blank cells

Hello everyone, I search and search for excel commands so I've decided to post my finding here that help me. If you find any of my Postings helpful and want to donate for my time, please check my profile! On with the tutorial.


Sum column cells ignore #N/A with formula

There is a formula can help you quickly sum up the column ignore #N/A.

Select a blank cell, C3 for instance, and type this formula

Code:

=SUMIF(A1:A14,"<>#N/A"),

press Enter key to get the result.




Tip: in above formula, A1:A14 is the column list you want to sum up, you can change it as you need.