How to include a string character with wildcard reference to cell - Countif

Country_Calc

New Member
Joined
Feb 14, 2017
Messages
13
I need to include a Comma plus 1 blank space to come before a wildcard reference to a cell content with countif/countifs

Here is how the formal looks without the comma and blank ", " added

=COUNTIF(ref_name,"*"&$A1&"*")


Is this possible?
 

Forum statistics

Threads
1,082,607
Messages
5,366,593
Members
400,905
Latest member
xcelstudent

Some videos you may like

This Week's Hot Topics

Top