Toppers,
Thanks again for your quick reply, however none of the above answers worked...
It may be because the cells i'm trying to add are spread through out the
spread sheet...as an example, one of my formulas is as follows:
=(B20+D20+G20+B41+D41+G41)...but G20 is the #N/A (because there is a formula
in G20), and B20 & D20 are numbers...so how do i tell it to add those 6 so
long as there is a number in there? Any further suggestions?

"Toppers" wrote:



=SUM(IF(ISNUMBER(A4:D4),A4:D4))

enter with Ctrl+Shift+Enter

"JC" wrote:

How do i get rid of the dreaded #N/A answer? I have a cell that is a sum of
6 cells, but those 6 cells are also sums of other cells...EX:

Group 1 fills out A1, A2 & A3...the fromula in A4 automatically sums those.
Group 2 fills out B1, B2, & B3...the formula in B4 automatically sums those.
Group 3 fills out C1, C2, & C3...the formula in C4 automatically sums those.

I want a sum of all of those, so in A10 I say =A4+B4+C4...however there
maybe some times when column C isn't filled in so there is an #N/A in C4, so
my sum in A10 will read #N/A instead of summing the two of three that are
filled in..any suggestions?