Hi, I am intermediate in Excel programming. I want to know how can we add the numerical values from "#N/A" and "#REF" areas while using "sum()" condition. I am getting counting value like "#N/A" after my formula usage. Please guide me. Examples added.

381
307
0
0
#N/A
#N/A
#N/A