Count if/ Count/ IF two columns if adjacent column = value, countif on other column

**catscats11** · 08-10-2017, 10:20 AM

Hi.
I currently have a set of Data that has a number in one column, and a set of text in the column adjacent to it.

I have attached an example to this post...
I would like a function/formula to basically say IF( Col A = 1 then COUNT( number of times "cat" occurs.
My real file has numbers 1 - 12, and a around 15 different text entries, all the formulas I have tried have resulted in it counting whatever "text" i enter for the entire column.

So as a result to the example,
number 1 : cat=2, cow =1, dog =3
number 2 : cow =1
number 3 : cat =2, dog =1
number 4 : dog =2

I hope I have made sense of this to you! Thank you for any help you can provide!! If you need any more info or explanation I can try to be more helpful.
Thanks again!

Note: I also need this to work for the entire column i.e. Col A2:A2300 because these entries are added to everyday.

**sweep** · 08-10-2017, 10:29 AM

Hi,

How about these formulae for numbers 1 and 2

=COUNTIFS($A$2:$A$27,1,$B$2:$B$27,"cat")
=COUNTIFS($A$2:$A$27,1,$B$2:$B$27,"cow")
=COUNTIFS($A$2:$A$27,1,$B$2:$B$27,"dog")
=COUNTIFS($A$2:$A$27,2,$B$2:$B$27,"cat")
=COUNTIFS($A$2:$A$27,2,$B$2:$B$27,"cow")
=COUNTIFS($A$2:$A$27,2,$B$2:$B$27,"dog")

**catscats11** · 08-10-2017, 10:34 AM

Perfect.
Thanks so much.

Count if/ Count/ IF two columns if adjacent column = value, countif on other column

LinkBack

Thread Tools

Rate This Thread

Display

Count if/ Count/ IF two columns if adjacent column = value, countif on other column

Re: Count if/ Count/ IF two columns if adjacent column = value, countif on other colum

Re: Count if/ Count/ IF two columns if adjacent column = value, countif on other colum

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] inrease count in column based on change to date in adjacent column

Count column value then adjacent column cell fill color

Specify range by value in one column to count # of cells w value > 0 in adjacent column

[SOLVED] Count Unique Values in a Column that are not in adjacent Column

Count a number in one column only for specfic input in adjacent column

Using COUNTIF to count column entries if adjacent column contains data

Using COUNTIF to count column entries if adjacent column contains data

Bookmarks

Bookmarks

Posting Permissions