Summing columns

[Debbie Dies]

I am setting up an array table to find a particular value.
The following is the formula I am using.
=VLOOKUP("4 OT Double Rate",WorkComp!$A$1:$AW$34
(HLOOKUP(A7,WorkComp!$A$1:$AW$2,2,0)),0)
If the is no match in column "A" it returns a value of #N/A.
Now when i try to sum my columns the sum returns a value of #N/A.
Is there a way to sum this value or to get the return value to return
0 so it can be summed

 

[Don Guillett]

have a look in HELP index for ISNA

 

[Debbie Dies]

Thanks Don. I have tried putting the ISNA into my formula. I quess
just don't quite know where I am suppose to insert it at, because
still cannot get it to add up. Thanks anyway

 

[Don Guillett]

=isna(yourformula) will be TRUE if it is so try

=if(isna(yourformula),"",yourformula)

 

[Dave Peterson]

or to show a 0:
=if(isna(yourformula),0,yourformula)