SOLVED

Using countif function

%3CLINGO-SUB%20id%3D%22lingo-sub-3369981%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20countif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3369981%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1389401%22%20target%3D%22_blank%22%3E%40NaomiT81%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DCOUNTIF(C2%3AC6%2C%22*foot*%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EYou%20can%20try%20to%20add%20the%20%22%20*%20%22%20sign.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3369949%22%20slang%3D%22en-US%22%3EUsing%20countif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3369949%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20spreadsheet%20for%20quantifying%20data%20on%20use%20of%20rights%20of%20way%2C%20which%20people%20can%20do%20on%20foot%2C%20bike%2C%20horse%20or%20non-motorised%20vehicle.%26nbsp%3B%20Is%20there%20a%20way%20I%20can%20use%20the%20countif%20function%20for%20entering%20multiple%20uses%20in%20the%20same%20cell%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20say%20someone%20says%20they%20use%20a%20path%20both%20on%20foot%20and%20on%20a%20bike%2C%20is%20there%20a%20way%20I%20can%20enter%20%3CSTRONG%3Efoot%2C%20bike%3C%2FSTRONG%3E%20into%20a%20cell%20and%20use%20countif%20to%20count%20both%20variations%3F%26nbsp%3B%20I'm%20still%20a%20fairly%20basic%20level%20user%20and%20entering%20%3Dcountif(J3%3AJ79%2C%20%22foot%22)%20returns%20a%20zero%20value%20for%20a%20cell%20containing%20%3CSTRONG%3Efoot%2C%20bike%3C%2FSTRONG%3E.%26nbsp%3B%20I%20want%20to%20be%20able%20to%20count%20usage%20separately%2C%20and%20I%20know%20I%20can%20set%20up%20multiple%20formulae%20for%20the%20same%20data%2C%20so%20I%20suppose%20my%20question%20is%20whether%20I%20can%20condense%20it%20into%20one%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20much%20appreciated%2C%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3369949%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3370005%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20countif%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3370005%22%20slang%3D%22en-US%22%3EPerfect!%20Thanks%20so%20much%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FLINGO-BODY%3E
New 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 (New Contributor)
Solution

@NaomiT81 

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

You can try to add the " * " sign.

Perfect! Thanks so much