Sumif & Isblank
 

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

Sumif & Isblank
 

Try:

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

HTH

"briank" wrote:

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

Sumif & Isblank
 

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

--
HTH

Bob Phillips

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

"briank" wrote in message
...
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

Sumif & Isblank
 

Thank you for your help! Works perfectly.

"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

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

"briank" wrote in message
...
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