Originally Posted by lumberjim 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))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Forum Rules
Bookmarks