Sumif & Isblank

[Guest]

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

 

[Guest]

Try:

=SUMIF(B1:B1529,">""",K1:K1529)

HTH

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[Guest]

Thank you for your help! Works perfectly.

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

--
HTH

Bob Phillips

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