What formula to use when adding cells in a row with #n/a

[BKG SPORTS]

EXCEL 2007

Hi,
I'm trying to add cells in a row, and some cells read #n/a, and some cells read a number.

say a2=4
b2=6
c2=#n/a

in d2, i would like to add those up, and it should be 10
but I can't seem to get the right formula.

Thanks for any help
BKG

[gak67]

You could try this:

Please Login or Register  to view this content.

[BKG SPORTS]

Ok, now I forgot one thing> in the row in trying to add
the cells are not next to each other:
example:b2=5, h2=10, k2=#n/a

IN p2 i need for it to read 15

Thanks
BKG

[FDibbins]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[gak67]

What's in the other cells? Upload a sample file and we don't need to go back and forth with limited information each time.

[BKG SPORTS]

Ok, now I forgot one thing> in the row in trying to add
the cells are not next to each other:
example:b2=5, h2=10, k2=#n/a

IN p2 i need for it to read 15

Thanks
BKG

[BKG SPORTS]

Ok, now I forgot one thing> in the row in trying to add
the cells are not next to each other:
example:b2=5, h2=10, k2=#n/a

IN p2 i need for it to read 15

Thanks
BKG

[gak67]

Look at post #5.

[FDibbins]

BKG, 2 things...
why do you repeat your posts? Posts 3, 6 and 7 are identical - stop repeating yourself.

and, more importantly, please comply with my request in post # 4. Other members will not post until you do

Thanks

[BKG SPORTS]

In the example;for Shaw, in p7, I want it to add cells b7,h7,and k7

Thanks

[FDibbins]

BKG, my apologies, I was looking for the change in the 1st post on this thread, I did not notice you had changed it in post 6. I have removed the infraction. For future reference, to change the title, change it on the 1st post

[BKG SPORTS]

I uploaded a example in post #10, anyone have any ideas?

Thanks
BKG

[gak67]

This in P7 works for your example:

Please Login or Register  to view this content.

[gak67]

I have refined it a little:

Please Login or Register  to view this content.

[BKG SPORTS]

I need to do the same for pinfall in Q7, when I copy it over, I get 0
What do I change?

[gak67]

In the totals the heading is PINFALL, but in the other headings it is PFALL. They need to match.

[BKG SPORTS]

Hey gak67, I got it

Thanks for your help
Much appreciated
BKG SPORTS