# Thread: Combing columns + ranges

1. ## Combing columns + ranges

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.

2. 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

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•