Cell reference

  • Thread starter Thread starter sc
  • Start date Start date
S

sc

On the below formula I would like to count if the data in A6 is contained in
A7 where A7 may have more data.

=COUNTIFS(A6,"=" & A7)

Specifically, A6 may be CE where A7 is CECFCG.
I'm not sure what to put in place of "=" to pull a wildcard type result of CE*
 
You are close

'use wildcard
=COUNTIF(A7,"*" & A6 & "*")

'combined with IF() function
=IF(COUNTIF(A7,"*" & A6 & "*"),"Yes","no")

If this post helps click Yes
 
Worked great, thanks. I really only needed the wild card after the entry so
=COUNTIF(A7,A6 & "*") is what I end up with. Didn't really understand the
cell reference format until now.
 
Back
Top