KK1966
08-20-2010, 08:16 PM
hI,
CODE BELOW, I WANTED IF RETURN VALUE =0 HOW DO IT = NOTHING?
PLEASE HELP ME TO CHANGE IT, MANY THXX
=SUMPRODUCT(((Details!$B$2:$B$4999=C7))*((Details!$K$2:$K$4999="COM18"))*((Details!$I$2:$I$4999&Details!$J$2:$J$4999="")))
CODE BELOW, I WANTED IF RETURN VALUE =0 HOW DO IT = NOTHING?
PLEASE HELP ME TO CHANGE IT, MANY THXX
=SUMPRODUCT(((Details!$B$2:$B$4999=C7))*((Details!$K$2:$K$4999="COM18"))*((Details!$I$2:$I$4999&Details!$J$2:$J$4999="")))