Sum if w. 2 criteria
 

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!!

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Jamie" schrieb im Newsbeitrag
...
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!!