Quote Originally Posted by lumberjim View Post
will sumproduct only work if the columns are adjacent?
If they are not adjacent you can use this version

=SUMPRODUCT(DEALS!M9:M408,(DEALS!E9:E408="N")*((DEALS!F9:F408=AA4)+(DEALS!G9:G408=AA4)>0))