Hi
IF(SUMPRODUCT(....)=0,"",SUMPRODUCT(...))

--
Regards
Frank Kabel
Frankfurt, Germany

"Danny J" schrieb im Newsbeitrag
...
Hi all,

OK I have the sumproduct working well, which is great....but how do I
set it
up so that if the result is going to be 0 the cell appears blank....I
have
bashed my brains with IF statements (the way I normally do this) but
I don't
think it will work.

Any ideas?

Danny