Count - Multiple Mixed Criteria (Number and Text)

**christopherprater** · 05-19-2012, 02:58 PM

Hey All,

Lets say column A is populated with recurring names and column B is populated with numbers. How would I go about counting all the "John Smith" entries in column A which have a number in column B of <=15?

Sumproduct cannot cope with mixed multiple criteria

Any alternatives?

**Søren Larsen** · 05-19-2012, 03:09 PM

Try this:

=COUNTIFS(A:A,"John Smith",B:B,"<=15")

**Søren Larsen** · 05-19-2012, 03:11 PM

BTW:

=SUMPRODUCT((A:A="John Smith")*1,(B:B<=15)*1) should also do the trick.

**christopherprater** · 05-19-2012, 03:29 PM

Soren,

Thanks very much for the response, both work beautifully. Did not realise there was a countifs function!

**Søren Larsen** · 05-19-2012, 03:56 PM

I'm glad I could help!

Count - Multiple Mixed Criteria (Number and Text)

LinkBack

Thread Tools

Rate This Thread

Display

Count - Multiple Mixed Criteria (Number and Text)

Re: Count - Multiple Mixed Criteria (Number and Text)

Re: Count - Multiple Mixed Criteria (Number and Text)

Re: Count - Multiple Mixed Criteria (Number and Text)

Re: Count - Multiple Mixed Criteria (Number and Text)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions