This work?
=IF(ISNA(LOOKUP(9.99999999999999E+307,L7:L516)),
0,LOOKUP(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 value’s and I
want to add them up for a total and n/a won’t allow me to get a total. Is
there a solution or another formula that would give me a 0 instead of n/a
thanks