G
Guest
Hi,
I have many linked sheets with multiple formulas. When I have yet to
populate a field, how can I get the formula to return a zero rather than an
#N/A when I sum my columns?
I'm currently using a combination of =if, lookup and vlookups across
multiple worksheets.
Thanks in advance...
I have many linked sheets with multiple formulas. When I have yet to
populate a field, how can I get the formula to return a zero rather than an
#N/A when I sum my columns?
I'm currently using a combination of =if, lookup and vlookups across
multiple worksheets.
Thanks in advance...