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

Please helps...

Jessica

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

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

Yes. This worked perfect. Thank you