SUM #n/a

  • Thread starter Thread starter sgrech
  • Start date Start date
S

sgrech

Hi,
I wonder if somebody can help with this. I need to sum a number of
cells, however some of these cells may contain #n/a. The sum function
doesn't like these values, can some suggest a suitable way to get
around this?/

Thanks
Simon
 
Try something like this:
=SUMIF(A1:A10,"<>#N/A",A1:A10)

Does that help?

Ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove #n/a in vlookup to sum results 6
Set add function ignore #N/A 1
sum, except #N/A 3
running sum needed with #N/A in array 3
Excel formula, sum the value cell and if empty cell left blank 0
Array Function to do a Sum of VLookUps that translate a letter gra 3
Ignoring Cells Returning #N/A 4
Sum in rows or columns that have #N/A in some cells! 18

Back
Top