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?

Maybe a small variation that avoids text in column B:

=sumproduct(--(C1:C7<""),B1:B7)



nada wrote:

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?

--

Dave Peterson

it did work, thanks a lot.

"Dave Peterson" wrote:

Maybe a small variation that avoids text in column B:

=sumproduct(--(C1:C7<""),B1:B7)



nada wrote:

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?

--

Dave Peterson

=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?

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?