SUMIF function syntax error. Want to sum values in column A if cells in column C are not blank or contains value more than zero

Sanjay1000R wrote:

I was entering the formula in a cell in same column where I wanted to sum the values in the cells below. I should have entered the specific cells range instead of column name in the formula.

If you have the formula in a Header or Footer Row then you can refer to the entire same column. I rarely use a specific cells range in Numbers (that is, several cells in the same column). Referring to the entire column, aside from looking cleaner, has the advantage of automatically including new cells when you add new rows to the table.

SG

Try

=SUMIF(D,"<>"&"",B)

(Also, if your region uses , as the decimal separator use ; instead of , in the formula )

SG

SGIII showed a general case but you don't really need the "" in the formula.

=SUMIF(D,"<>",B)

Hi Sanjay1000R,

From your screen shot,

I can not see any values in Column A.

The one value in Column C appears to be text.

The values in Column D are either Text or Date.

What is your overall aim? I do not understand you question:

Sanjay1000R wrote:

SUMIF function syntax error. Want to sum values in column A if cells in column C are not blank or contains value more than zero

More information may lead to a solution.

Regards,

Ian.

I was looking over this thread again and got to wondering if we provided you the correct answer. Yellowbox questioned what you meant by summing "values in column A [actually column B] if cells in column C [actually column D] are not blank or contains value more than zero" and I am now wondering about that, too. Column D contains dates, which are not comparable to "more than zero" so that last part of your question does not make sense. Did you mean you want to sum the values in column B if column D is not blank AND column B is >0?