Finding Data in 2 Columns

Kyle Lewis

Hi,

I am having trouble finding data that meets certain criteria across 2 columns. I have several status's that have "In Process" included in the column "Status". I also have a column named "Priority" with several priority levels. 

I need to find how many cells have "Low" in the Priority column AND have "In Process" in the Status column. 

Attached are screenshots of my Priorities and Status's

Here is the formula I attempted :=COUNTIFS({Beaumont FS/PM Range 1}, "Low", FIND("In Process", @cell) > 0)

Any help is appreciated. 

Kyle

Jim P

Since you are using COUNTIFS, you can do it all as one formula. Try "=COUNTIFS(Status:Status, "In Process", Priority:Priority, "Low")

 

OR

"=COUNTIFS(Status:Status, FIND("In Process"), Priority:Priority, "Low")

Status and Priority would be replaced with the column name you are using. If it is a 2 word column name, use [ ], [New Status]. 

 

Only use the "Reference Another Sheet" if you are actually referencing another sheet. The symbols {} mean you are referencing another sheet.