If it is just for display you can use a custom format like
General;-General;;
which will "hide" zeros
--
Regards,
Peo Sjoblom
(No private emails please)
"Robert" wrote in message
...
Thank you, they both work and return 0 instead of any error messages.
However, is there a way to get a blank cell instead of 0 if the total is
less
than 1?
thanks,
Robert
"Peo Sjoblom" wrote:
Wouldn't this work?
=SUMIF(Technicians!A:A,$G$2,Technicians!BG:BG)+SUM IF(Technicians!A:A,$G$2,Technicians!BH:BH)
--
Regards,
Peo Sjoblom
(No private emails please)
"Robert" wrote in message
...
Hello,
I simply need to lookup 2 cells on another sheet and add them together
without producing any errors if one or both of them is blank. I am
using:
=SUM(IF(ISNUMBER(LOOKUP($G2,Technicians!A:A,Techni cians!BG:BG)),(LOOKUP($G2,Technicians!A:A,Technici ans!BG:BG)),""),(IF(ISNUMBER(LOOKUP($G2,Technician s!A:A,Technicians!BH:BH)),(LOOKUP($G2,Technicians! A:A,Technicians!BH:BH)),"")))
This will add the numbers together if there is a number in each cell,
but
I
get the #VALUE error if one of them is blank. The (IF ISNUMBER) portion
of
it
was intended to avoid errors, but is not working here. Any help
appreciated...
thanks,
Robert
|