# COUNTIF(S) multiple criteria (text & text)

1. ## COUNTIF(S) multiple criteria (text & text)

Hello again,

I need a formula to count all text in two columns that meet this criteria.

Column B "New" and Column U "Completed"

I am trying to get one formula to count 2 different columns of criteria. For example, If column B has the word "New" 2x and column U has the word "Completed" 1x, in the same row as the first criteria. My total count would be = 1

Column B Column U
New
New Completed

Jessica

2. ## Re: COUNTIF(S) multiple criteria (text & text)

You should just be able to use countifs straight up if I am understanding the problem correctly.

=countifs(column B,"New", Column U, "Completed")

David

3. ## Re: COUNTIF(S) multiple criteria (text & text)

David is absolutely correct ... simple and succinct ... just change one little thing to make it slightly clearer
=COUNTIFS(B:B,"New",U:U,"Completed")

4. ## Re: COUNTIF(S) multiple criteria (text & text)

Yes. This worked perfect. Thank you

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1