• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting a specific item among multiple entries

M

Muhammad Shakeel

New Member
I have a list similar to the one given below and i have to count a value (for example "DCDF") in this list, the "COUNTIF" calculates the entry (DCDF) in the cell where it exists alone but not in the cell where there is another entry present alongwith "DCDF"


DCDF

DCDF,MNAC,MXAC

NVAR,NVAO,DCDF

BDCF,DCDF

DCDF


The "countif" formula to count "DCDF" in the above list gives the result "2" whereas actually it exists five times in the above list.

Is there any other formula to handle this situation?
 
Hi Shakeel,


Welcome to the Chandoo's forum!!


Assuming your data is in column A, use this formula to find Count of "DCDF":


=COUNTIF($A$1:$A$5,"*"&"DCDF"&"*")


Regards,

Faseeh
 
Good day Muhammad Shakeel

Cells in column A containing INC

=COUNTIF(A1:A100,"INC*") ,put you wild cards where you want..=COUNTIF(range,"?*")
 
This was discussed here: http://chandoo.org/wp/2011/11/07/formula-forensics-002/
 
You must log in or register to reply here.
Back
Top