Count between two columns if looking for non-blanks in one of them

Nancy Heater

Hi all.

We have (2) columns: Tracking and Project/PO.

We need to count all of the cells in "Tracking" that have a tracking number i.e. are NOT blank, but at the same time NOT counting any cells from a row that also contain the word "Lab" in "Project/PO"

These are the two versions we have tried, based on other similar formulas, but it is not working.

=COUNTIFS((TRACKING:TRACKING), <>"") - COUNTIFS((TRACKING:TRACKING), <>""), [PROJECT/PO]:[PROJECT/PO],CONTAINS("LAB",@cell))

=COUNTIFS((TRACKING:TRACKING), NOT(ISBLANK(@cell) - COUNTIFS((TRACKING:TRACKING), NOT(ISBLANK(@cell), [PROJECT/PO]:[PROJECT/PO],CONTAINS("LAB",@cell))

Thanks in advance for the help, as always!

-N

Andrée Starå

Hi @Nancy Heater

I hope you're well and safe!

Try something like this. You were close.

=COUNTIFS(Tracking:Tracking, <>"", [Project/PO]:[Project/PO], NOT(CONTAINS("Lab", @cell)))

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!