SOLVED

Using countif function

Copper Contributor

I'm trying to create a spreadsheet for quantifying data on use of rights of way, which people can do on foot, bike, horse or non-motorised vehicle.  Is there a way I can use the countif function for entering multiple uses in the same cell?

 

So say someone says they use a path both on foot and on a bike, is there a way I can enter foot, bike into a cell and use countif to count both variations?  I'm still a fairly basic level user and entering =countif(J3:J79, "foot") returns a zero value for a cell containing foot, bike.  I want to be able to count usage separately, and I know I can set up multiple formulae for the same data, so I suppose my question is whether I can condense it into one formula.

 

Any help much appreciated, thanks.

2 Replies
best response confirmed by NaomiT81 (Copper Contributor)
Solution

@NaomiT81 

=COUNTIF(C2:C6,"*foot*")

You can try to add the " * " sign.

Perfect! Thanks so much :)
1 best response

Accepted Solutions
best response confirmed by NaomiT81 (Copper Contributor)
Solution

@NaomiT81 

=COUNTIF(C2:C6,"*foot*")

You can try to add the " * " sign.

View solution in original post