Combing columns + ranges

bplotts

New member
Joined
May 18, 2015
Messages
1
Reaction score
0
Points
0
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.
 
Not quite sure what you’re looking for, you can try this:
If this is not what you’re looking for show what you would like the resulting column to look like.


Column C
In C1 write Dog
Insert formula into (C2) =SUMIFS($A2:$A$20,$B2:$B$20,$C$1)

Column D
In D1 write Cat
Insert formula into (D2) =SUMIFS($A$2:$A$20,$B$2:$B$20,$D$1)

Column E
In E1 write Goat
Insert formula into (E2) =SUMIFS($A$2:$A$20,$B$2:$B$20,$E$1)

Column Results would be:

C
DOG
4

D
Cat
2

E
Goat
0
 
Back
Top