PDA

View Full Version : VALUE = NOTHING



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="")))

Simon Lloyd
08-21-2010, 01:08 AM
I can't really understand what you want other than this:

=SUMPRODUCT(((Details!$B$2:$B$4999=C7))*((Details!$K$2:$K$4999="COM18"))*((Details!$I$2:$I$4999&Details!$J$2:$J$4999=0)))

Bob Phillips
08-21-2010, 03:23 AM
What is the question?