SOLVED

New Contributor

# Using countif function

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 (New Contributor)
Solution

# Re: Using countif function

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

You can try to add the " * " sign.

# Re: Using countif function

Perfect! Thanks so much