Excel Sum Only Numbers ignore #N/A

While working in excel you may have faced this issue that you want to do sum of column or row that contain “#N/A” due to this you can’t apply sum formula because it will throw error. Here we will understand this and solve this issue with example.

Let’s Understand with Example – #N/A

Suppose this is the data you are working on it and you want sum of the above if you use SUM formula it will through as below shown:

To solve this issue you need to remove #N/A and then apply the formula and it will work. Here our target is not this our target is that even data has #N/A then also that formula work without deleting it.

So to solve this issue we will use SUMIF formula and it will ignore the #N/A. Let’s see with the above example.

Excel Sum Only Numbers ignore #N/A

so you need to use the formula in this way =SUMIF(C2:C17,”<>#N/A”)

In this way you can solve this issue and do your work without any worry. Here you need not to remove #N/A only use sumif formula and it will work.

If this article solved your query share with others and it will also help others- Sharing is caring. Thanks for showing your interest.

For more Learning: https://www.youtube.com/c/EduTaxTuber