How to count text entered with ALT+ENTER using a count function

**bethy1234** · 05-29-2015, 11:12 AM

Hi guys,

i would like to use a count function(possibly =countif()) to count through out a column. in that column i have cells with multiple entries.

Scenario

So for example, cell a1 could contain "Paul", "John" and "Andy". Cell a2 could contain "Paul", "John" and "peter". Cell a2 could contain "Paul", "Nigel" and "peter".

i want to be able to count the number of "Paul's" that occur through out column A. The count formula should return the value: 3 as there are 3 "Pauls" entered in column A.

Please bear in mind that there are multiple entries in each cell that have been separated by ALT+ENTER. I have tried in vain to successfully carry out any formulae containing ALT+ENTER.

Can you help?

Best

Andy

**jhren** · 05-29-2015, 11:58 AM

Array formula (requires entry confirmation: Ctrl+Shift+Enter)

Formula:

Please Login or Register  to view this content.

...where C1 is the name (or text) you are wanting to count.

**bethy1234** · 05-29-2015, 02:41 PM

Hi there,

I have just found my own solution which is :=COUNTIF(A:A,"*paul*"). The solution was to simply use the wildcard symbol.

Thanks anyway.

How to count text entered with ALT+ENTER using a count function

LinkBack

Thread Tools

Rate This Thread

Display

How to count text entered with ALT+ENTER using a count function

Re: How to count text entered with ALT+ENTER using a count function

Re: How to count text entered with ALT+ENTER using a count function

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] COUNT function does not count values beginning with text

[SOLVED] Formula needed to only count total cells entered and not count adjacent text entered cells

[SOLVED] Count/No Count for year entered---formula help

[SOLVED] Count Intervals of Filtered TEXT values in Column and Return Count across a Row

Count Intervals of Filtered TEXT values in Column and Return Count across a Row

Bookmarks

Bookmarks

Posting Permissions