Summing columns

D

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
 
D

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
 
D

Don Guillett

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

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