Count if example..

**VegasL** · 05-24-2012, 01:23 PM

Hello,

I'm trying to do countif, if coulm d matches column a

In column d, I want to count the number of times word was used in column a, then show the total count, result is in column e.

in column f, how many times phrase was used in column a.

so need formula for columns e and f.

Thanks in Advance

**Haseeb Avarakkan** · 05-24-2012, 01:42 PM

Hello Vegas,

Use SUMIF & COUNTIF with wildcard,

E2, copy down

=SUMIF(A:A,"*"&D2,B:B)

F2, copy down,

=COUNTIF(A:A,"*"&D2)

If kwd may appear anywhere in the cells, use one more "*" after the cell. like,

=SUMIF(A:A,"*"&D2&"*",B:B)

**Ron Coderre** · 05-24-2012, 01:43 PM

I can't quite figure out what exactly you're looking to count, but...here are some guesses (using your posted workbook)

This regular formula returns the count of Col_A cells that contain the Col_D value

Please Login or Register  to view this content.

This regular formula returns the number of times the Col_D value occurs in Col_A (assuming some cells may contain repeated values..."White Ponys are white ponys" would count as 2 occurrences

Please Login or Register  to view this content.

Using the sample data,
E2 returns: 3
F2 returns 3

Is that something you can work with?

**dilipandey** · 05-24-2012, 01:44 PM

Hi Vegasl,

See the attached file which has been solved as per your requirement. thanks.

Countif Example.xlsx
Regards,
DILIPandey

<click on below 'star' if this helps>