Hello I have two columns that I need to match then count based on certain criteria. Example
Column 1 Column 2
1 Dog
1 Dog
1 Cat
0 goat
0 cat
0 dog
1 dog
1 dog
0 dog
What I'd like to say is "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Dog, then count the "1's" in column 1. "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Cat, then count the "1's" in column 1. Etc.
Anyone assist? Thank you very much.
Column 1 Column 2
1 Dog
1 Dog
1 Cat
0 goat
0 cat
0 dog
1 dog
1 dog
0 dog
What I'd like to say is "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Dog, then count the "1's" in column 1. "If the range in column 1 is equal to 1 AND the range in column 2 is equal to Cat, then count the "1's" in column 1. Etc.
Anyone assist? Thank you very much.