debra2345Copper ContributorJan 11, 2024help with countif I'm trying to count how many times 1C. & 1A. appear in the column. I've tried =COUNTIF(I2:I5,"1c.") & =COUNTIF(I2:I5,"1c. Farm your yard") but the results 0. can someone tell me what I'm doing ...Show More
mtarlerSilver ContributorJan 11, 2024try using the wildcard character * so something like:=COUNTIF(I2:I5,"1c.*")
