Sum if w. 2 criteria

[Jamie]

I have columns in a sheets that I am trying to add sales of one column if
they meet two criteria - Column C=north and Column J=1 then I want to add all
sales.

Help!!

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(C1:C100="north"),--(J1:J100=1),K1:K100)
if column K contains your sales values.

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html