Syntax for "Not Blank"

[KKD]

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"?

 

[Jarek Kujawa]

try:

=sumif(N:N,">0")
for >0

or

=sumif(N:N,"<>""")
for not blanks

pls click YES if this helped

 

[Dave Peterson]

=SUMIF(N:N,"<>",H:H)

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"?