sumproduct problem
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
|