A is the count, B is the text to be counted, C is the range. I am wanting to be able to place a formula such as "countif(C1:C10, *B1*)" in cell A1 and drag down. It only needs to contain the B1 text not be exact. I want to avoid having to type in "*:001*", "*:002*" etc. in column A. Columns B & C are both stored as text values.
A B C
1 :001 01:003
3 :002 02:002
1 :003 03:002
1 :004 04:001
0 :005 05:003
1 :006 01:006
0 :007 02:008
1 :008 03:004
0 :009 04:005
0 :010 05:002
try below in A1
=COUNTIF($C$1:$C$10,"*"&$B1&"*") and drag down
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
smit.etha, I assume that there is a mistake in your first post and that cell A3 should read 2. If not, can you explain why it should be 1. If you did make a mistake, then Hemesh's solution is spot-on.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Ya there was a mistake in A3. I type all those values in by hand and miscounted. hemesh was spot on so thank you both very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks