To count occurances of a particular number or words in a range of excel cells use formula
=COUNTIF(range,"pattern")
where range is the excel cells range where you want to search for the pattern. pattern can be numbers or words but it should be within double quotes "".
Example - To count number of occurance of word "present" in cells between A1 to A10. frame the formula like below
ex - COUNTIF(A1:A10,"Present")
also you can wildcard characters in the pattern.
Example =COUNTIF(A1:A9,"*sent")
=COUNTIF(range,"pattern")
where range is the excel cells range where you want to search for the pattern. pattern can be numbers or words but it should be within double quotes "".
Example - To count number of occurance of word "present" in cells between A1 to A10. frame the formula like below
ex - COUNTIF(A1:A10,"Present")
also you can wildcard characters in the pattern.
Example =COUNTIF(A1:A9,"*sent")
Some truly wonderful work on behalf of the owner of this internet site , perfectly great articles . this
ReplyDelete