Nested IF,COUNTA, and COUNTIF problem

What I need to do is to COUNTA and COUNTIF on specific columns only on rows where a different column contains specific information, I'll try a visual below...


A B C
1 0 1
1 1 1
1 0 0
1 1 1
2 1 0
2 1 0

I need the function to check column a, if a=2, then I want it to countif columns b and c separately (functions will be separate for each column).

Here's a sample of what I'm trying to use:

Please Login or Register  to view this content.

But it's giving me an error with the "I141E" section. This is an ID I'm checking to try and separate data without doing it manually.

*UPDATE*
I realized I can do the COUNTA function I need by simply utilizing the original "A" column, but I'm still stumped on how to COUNTIF on columns "b" and "c" only on row which contain specific data "2" in column "A"...

Instead of giving us your formula could you post what the expected result is.


VBA Noob

Still not sure what your after but see if this helps

=SUMPRODUCT(--(A1:A6=1)*(B1:B6=1)*(C1:C6=1))

If Col A and Col B and Col C all equal 1 then it counts once. See for your example it will return 2.

VBA Noob

Try

=SUMPRODUCT(--(A1:A9="I141H")*(B1:B9=5))

VBA Noob