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