Hello Friends
Please find the attached 2010 excel file <Excluding and Including 151115>.
I want to count for `Q' and `S' (Cells K1:K2) in Column E, by excluding `A', `C' in Column A (Cells G1:G2), by excluding `N', `O' in Column B (Cells H1:H2), by excluding `Y' in Column C (Cell I1), by excluding `1' in Column D (Cell K1:K2).
The answer need to be plot in light yellow cell L1.
Please refer the `Filter' Sheet for Filter example Light Yellow cells shows count `39'.
Kindly refer sheet `Sheet3' for 1 example.
I tried the below formula but it shows error <=SUMPRODUCT(--(NOT(ISNUMBER(MATCH($A$1:$A$1000,$G$1:$G$7,0)))),--(NOT(ISNUMBER(MATCH($B$1:$B$1000,$H$1:$H$7,0)))),--(NOT(ISNUMBER(MATCH($C$1:C$1000,I$1:I$7,0)))),--(NOT(ISNUMBER(MATCH($D$1:D$1000,J$1:J$7,0))))--((ISNUMBER(MATCH($E$1:E$1000,K$1:K$7,0)))))>.
http://www.excelforum.com/excel-form...ml#post4236012
thanks in advance
thilag
Bookmarks