Using a cell with N/A

[Mavman]

Say I have cells A1=3, A2=3, A3=N/A, A4=5, A5=1. Now I want to put an equation in cell B1 and I want to add A1+A2+A3+A4+A5 and have it come up with 12 instead of an error. Can you please help me.

Thank you

[greentea]

if you have excel 2007, try =iferror((A1 + A2 + A3 ....),0)

[nawas]

Hi,

Try this formula =SUMIF(A1:A5,"<>n/a")


Thanks

[DonkeyOte]

Further to nawas' suggestion - if you wanted to account for other errors also you could use:

Please Login or Register  to view this content.

[Mavman]

Thank you everyone for your reply's. You helped out a great deal.