I am trying to use a countif with other qualifying variables frm other columns in the same row.
I want to get a count of non numberical data in 2 colums if both conditions are met.
I would like to make this happen:
Do not count if the data in A is not an X. X is the actual data, not a placeholder.![]()
=countif (c1:c100,"YES") if (A1:a100)="X"
I tried SumProduct and SumIf, and Count(If...) but I am missing something someplace.
Anyhelp is appreciated.
Bookmarks