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:
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"...
Bookmarks