Thread: Sumif & Isblank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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