I have a column with multiple values with some separated by a comma. I am using a COUNTIF function to get the count of values - for example, I have a worksheet "Data" from where I am pulling the data as is shown in this formula:
=COUNTIF(Data!D:D,"*Gift cards*")
I am putting the "*" before and after the value to make sure I am including the comma and putting the name of the value (in this case "Gift cards".
Is there a way to pull this data dynamically without having to put the value name? For example: COUNTIF(Data!D:D,"H5") and making sure I am also accounting for values separated by comma?
<tbody>
</tbody>
=COUNTIF(Data!D:D,"*Gift cards*")
I am putting the "*" before and after the value to make sure I am including the comma and putting the name of the value (in this case "Gift cards".
Is there a way to pull this data dynamically without having to put the value name? For example: COUNTIF(Data!D:D,"H5") and making sure I am also accounting for values separated by comma?
Column D | |
e-Gift cards,Gift cards | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody>
</tbody>