Countif Excluding and including parameters

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

Yes, it is error, but my requirement is to exclude G1:J2 (Exclude A, C, N, O, Y, 1) in respective columns and include i.e., count for T, if so then the result should be 39. But your formula shows 58 (58 = 19+39, Counted 19 including blank cells in the column A:D). This blank should be avoided.

thanks
thilag