JAaron Anderson
asked on
Excel formula HowManyTimes a String Exists in Range
If I had the provided sample range, what formula could I make to count how many 3s there are all together ? thanks
I tried the following thinking it would work
=SUM(IF(ISNUMBER(FIND(I2,A2:F16)),1,0))
sampledata.txt
use countif
From your sample data:
=COUNTIF(A1:F15,3)
But maybe you need something else.
Thomas
=COUNTIF(A1:F15,3)
But maybe you need something else.
Thomas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=COUNTIF(A2:F16,3)
Sample:
Sample.xls
Sample.xls
ASKER
thx
ASKER