View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Hendrickson Josh Hendrickson is offline
external usenet poster
 
Posts: 1
Default SUMIF cells in Column B are blank

I am trying to figure out how to sum numbers in column A but only if the
cells in the corresponding row in column B are blank. Any ideas?

I thought this would work but it hasn't so far

=SUMIF(B:B, ISBLANK(B:B), A:A)