sumproduct problem
thank u so much.
"Bob Phillips" wrote:
=SUMIF(C1:C7,"<",B1:B7)
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"nada" wrote in message
...
hi all,
i entered in B2 =if(LEN A2=0,"",A2) so if A2 is blank B2 will appear blank
but for example if i tried to enter in another cell the following:
sumproduct((C1:C7<"")*B1:B7) it returns error value as it sees B2 not
blank,
can anyone help me?
|