Sum Calculation with 2 columns of criteria

[Perresa]

I am trying to determine a dollar value sum of items that meet two
different criteria in 2 different columns. I have tried using SUMIF
and DSUM and can't get them to work. Is it possible to do this?

Ex: If Column C equals "Y" and Column D equals "Food", then add the
dollar value in Column J to the total, otherwise ignore the value in
the total.

Thanks in advance for any assistance or advice you can provide.

 

[JE McGimpsey]

I am trying to determine a dollar value sum of items that meet two
different criteria in 2 different columns. I have tried using SUMIF
and DSUM and can't get them to work. Is it possible to do this?

Ex: If Column C equals "Y" and Column D equals "Food", then add the
dollar value in Column J to the total, otherwise ignore the value in
the total.

One way:

=SUMPRODUCT(--(C1:C1000="Y"),--(D11000="Food"),J1:J1000)

Expand or contract your ranges to suit - Array functions (while
SUMPRODUCT doesn't have to be array-entered, it's still an array
function) can't take entire rows/columns as arguments. It doesn't hurt
to have blank rows.