Replace specific reference with a wildcard

[RodneyW]

I'm using this formula:

=COUNTIFS($F$8:$F$10000,"News",$A$8:$A$10000,"Sports")

I would like to replace "News" and also "Sports" with wildcards meaning as long as there is some value in F and A, it will add to the count. If the cell is empty/has no value, it won't add to the count. Note there will always be a value in A. Once I have this portion resolved, I'll have a follow up question.

Thanks in advance.

 

[Fluff]

How about

=COUNTIFS($F$8:$F$10000,"*",$A$8:$A$10000,"*")

 

[RodneyW]

Thanks for the reply. I'm afk for the next couple hours and will try it when I return. If I wanted to modify this so that rather than counting all values in A, it counted UNIQUE values in A where the criteria in F was met?

 

[Fluff]

That is a totally different question & will need a new thread.

 

[RodneyW]

How about

=COUNTIFS($F$8:$F$10000,"*",$A$8:$A$10000,"*")

Thanks, this works. I will be posting the other question in a new thread

 

[Fluff]

You're welcome & thanks for the feedback.