Add 4 cells together, ignore the ones with text in

[dvent]

Hi Guys,

I have 4 cells that I want to add together. There will always be one with numbers in, and others with text. I want to therefore say A1+B1+C1+D1 and come out with a numerical value. How do ignore the text cells and just add the numbers?

Thanks!

[mudraker]

=sum(a1,b1,c1,d1)

[dvent]

=sum(a1,b1,c1,d1)

Thanks.

Now I need help incorporating this into a bigger formula.

I have

=IF(EH8="Not Started","N/A",HELP HERE)

I want it to say something like:

=IF(EH8="Not Started","N/A",=sum(ea1,eb1,ec1,ed1))

but that doesn't seem to work?!

Please help

Thanks!

[mudraker]

Drop the = sign in front of the Sum command

=IF(EH8="Not Started","N/A",sum(ea1,eb1,ec1,ed1))

[dvent]

Drop the = sign in front of the Sum command

=IF(EH8="Not Started","N/A",sum(ea1,eb1,ec1,ed1))

Thanks alot