Count if one cell or a second cell has specific information

First,
Thank you for helping.

I have an issue that I have not seen in any forum.
I need to count only 2 specific cells in a row (column L, all cells) and a cell in the same row but in Column P.
I need this to be valid to count over 500 rows in a worksheet in the spreadsheet.
Currently I am using

=COUNTIFS('CSC & SOX apps'!$L:$L,"*Q1*",'CSC & SOX apps'!$P:$P,"Q1",'CSC & SOX apps'!$W:$W,"*"&$B8&"*")

Which results in 0 as it is counting only if "Q1" is in both cells.

The need is to count each cell as ! and add the row together to be either 0, 1, or 2 per row depending upon the number of "Q1" in the 2 cells.
Thank you,

GLenn,
Thank you.

How would I also bring the 'CSC & SOX apps'!$W:$W,"*"&$B8&"*" part of the formula into the equation as it needs to be part of both of the counts

I am using to count for people in a list I am using.

I have created a spreadsheet to show what I am trying to do .
Thank you,

Atul,
Does this also count Cell M2 into account? IT has to count both M and O individually but the name has to be consistent in the row to place under correct VP.

Maybe this would clarify as "how to count column M OR column O that has VP in the row."

Thank you,
I figured out by both of the suggestions a working formula,


=COUNTIFS('CSC & SOX apps'!$L:$L,"Q1",'CSC & SOX apps'!$W:$W,"*"&$B7&"*")+COUNTIFS('CSC & SOX apps'!$N:$N,"Q1",'CSC & SOX apps'!$W:$W,"*"&$B7&"*")