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.

Kyle Lewis

I tried both formulas on the sheet. The first one returned 0 when it should have been 11. The 2nd on gave me an incorrect argument. 

Andrée Starå

Hi Kyle,

Are the columns on different sheets or the same one?

Can you describe your process in more detail and maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

You will want to use something along the lines of this...

 

=COUNTIFS({Beaumont FS/PM Priority Column}, "Low", {Beaumont FS/PM Status Column}, FIND("In Process", @cell) > 0)

 

All you were missing was establishing the different ranges for each set of criteria.

Kyle Lewis

Thanks for the help guys! 

I ended up with the formula Paul suggested.

Paul Newcome

Happy to help! 

Andrée Starå

Excellent!

Happy to help!