jensorr - - Latest reply:
sambr22

- Posts
- 1
- Registration date
- Thursday April 21, 2016
- Last seen
- April 21, 2016

Related:

- Excel number of times a value appears
- Excel count how many times a value appears in a column - Best answers
- Count number of times a value appears in excel - Best answers
- Excel count how many times a number appears ✓ - Forum - Excel
- How many time a name appears in excell - How-To - Excel
- It appears that call of duty did not quit properly the last time it ran ✓ - Forum - Call Of Duty
- Count appearances of specific words in Excel ✓ - Forum - Word
- Popcorn time download - Download - Video

Best answer

Suppose your data is in Column A then paste this formula anywhere or in A12 and Press Ctr+Shift+Enter as this is any Array formula ....... After pressing Ctr+Shift+Enter to enter the formula you will see {} will occur around the formula ={SUM(IF(ISERROR(SEARCH("*a*",A1:A10,1)),0,1))} ... never try to enter {} manually ....

Array Formula : After entering the formula Press Ctrl+Shift+Enter

Array Formula : After entering the formula Press Ctrl+Shift+Enter

=SUM(IF(ISERROR(SEARCH("*a*",A1:A10,1)),0,1))

A few words of thanks would be greatly appreciated. Add comment

4333 users have said thank you to us this month

The array formula works, but it takes too much computer power to calculate and will make the workbook larger in size. Use the COUNTIF formula with the conjunction of the wild card ("*").

IF CELL B1, contains the following values: a, b, c, d, e, f, g

and cell B2, contains the following values: a, b, c, d, e, f, g

You want to know how many times the value "a" shows up in column B across all the cells. The formula to use would be:

=COUNTIF($B:$B,"*"&"a"&"*")

the formula should return quantity of 2, since a is showes up in cell B1 and B2.

IF CELL B1, contains the following values: a, b, c, d, e, f, g

and cell B2, contains the following values: a, b, c, d, e, f, g

You want to know how many times the value "a" shows up in column B across all the cells. The formula to use would be:

=COUNTIF($B:$B,"*"&"a"&"*")

the formula should return quantity of 2, since a is showes up in cell B1 and B2.