Joel,

You left out a parenthesis before the first comma, should have two.

Alan


"Joel" wrote:

=if(isna(LOOKUP(9.99999999999999E+307,L7:L516),0,L OOKUP(9.99999999999999E+307,L7:L516))


"gwbdirect" wrote:

I am using this formula to get the last value in the column
=LOOKUP(9.99999999999999E+307,L7:L516)
The problem is when it has no value instead of 0 it gives me #n/a.
This is a problem because I have different sheets that have values and I
want to add them up for a total and n/a wont allow me to get a total. Is
there a solution or another formula that would give me a 0 instead of n/a
thanks