May 13 2022 04:37 AM - edited May 13 2022 04:48 AM
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.
May 13 2022 04:44 AM
SolutionMay 13 2022 04:44 AM
Solution