Sumif & Isblank

B

briank

I would like to use the sumif command with isblank. Currently I am trying to
get this command: =SUMIF(B1:B1529,"isblank()=false",K2:K1529) to work. It
is my desire to total up Column K with all numbers associated with a name in
Column B. Any suggestions?

Col B Col K
Jones 750
Smith 250
300
Case 125
Smart 60
 
B

Bob Phillips

=SUMIF(B2:B6,"<>",K2:K6)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

briank

Thank you for your help! Works perfectly.

Bob Phillips said:
=SUMIF(B2:B6,"<>",K2:K6)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
Click to expand...
 
Top