View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKD KKD is offline
external usenet poster
 
Posts: 31
Default Syntax for "Not Blank"

I am trying to write a formula that only sums the values from the amount
column if there is a date in the date column...what is the syntax for this?
My formula is a SUMIF:

=sumif(N:N,0,(H:H))

Excel does not accept the 0, how should this be written to say "when this
cell is not blank"?
--
KKD