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