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

Syntax for "Not Blank"
 

try:

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

or

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

pls click YES if this helped




On 27 Maj, 23:05, KKD wrote:
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

Syntax for "Not Blank"
 

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

KKD wrote:

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

--

Dave Peterson