Ignoring n/a in formulas

[DKS]

Does anyone know how to ignore n/a's when using formulas. I am trying to sum up a large sum of data and it is okay that some have n/a's but need the total of the group to add up. I have used the sumif formula but that doesn't work if I have to reference another cell when computing.

 

[Domenic]

Does anyone know how to ignore n/a's when using formulas. I am trying to sum
up a large sum of data and it is okay that some have n/a's but need the total
of the group to add up. I have used the sumif formula but that doesn't work
if I have to reference another cell when computing.

Try,

=SUM(IF(ISNUMBER(A1:A10),A1:A10)), entered using Ctrl+Shift+Enter

and adjust your range accordingly.

Hope this helps!

 

[Peo Sjoblom]

One way

=SUMIF(A1200,"<>#N/A")

--

Regards,

Peo Sjoblom

Does anyone know how to ignore n/a's when using formulas. I am trying to

sum up a large sum of data and it is okay that some have n/a's but need the
total of the group to add up. I have used the sumif formula but that
doesn't work if I have to reference another cell when computing.

 

[Frank Kabel]

Hi
one way: enter the following array formula (with CTRL+SHIFT+ENTER)
=SUM(IF(ISNA(A1:A100),,A1:A100))

 

[Jason Morin]

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

HTH
Jason
Atlanta, GA

-----Original Message-----
Does anyone know how to ignore n/a's when using

formulas. I am trying to sum up a large sum of data and
it is okay that some have n/a's but need the total of the
group to add up. I have used the sumif formula but that
doesn't work if I have to reference another cell when
computing.