Counting number of times a value appears if..
Solved/Closed
jensorr

sambr22
sambr22
 Posts
 1
 Registration date
 Thursday April 21, 2016
 Status
 Member
 Last seen
 April 21, 2016
Related:
 Excel count how many times a value appears in a column
 How do i count the number of times a value appears in a column in excel?  Best answers
 Count number of times a value appears in a column  Best answers
 Excel count how many times a name appears  HowTo  Excel
 Excel count how many times a number appears ✓  Forum  Excel
 Excel repeat cell x times  HowTo  Excel
 Excel duplicate rows n times ✓  Forum  Excel
 Copy/paste a range 'n' times. ✓  Forum  Excel
3 replies
mubashir aziz
 Posts
 190
 Registration date
 Sunday April 12, 2009
 Status
 Member
 Last seen
 February 16, 2010
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))
Artemis
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.
sambr22
 Posts
 1
 Registration date
 Thursday April 21, 2016
 Status
 Member
 Last seen
 April 21, 2016
Hi, if I have a column of values from an open question on a survey, how can I see:
 what words were said
 how many times each word were said
For instance, a participant may say that they like a TV because it is: cool, smart, useful.
 what words were said
 how many times each word were said
For instance, a participant may say that they like a TV because it is: cool, smart, useful.
stuzzy
doesnt work for me. says thers none of the data im looking for in the cells im searching when there clearly is