sumproduct problem

[nada]

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]

Maybe a small variation that avoids text in column B:

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

 

[Bob Phillips]

=SUMIF(C1:C7,"<>",B1:B7)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[nada]

thank u so much.

=SUMIF(C1:C7,"<>",B1:B7)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[nada]

it did work, thanks a lot.

Maybe a small variation that avoids text in column B:

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