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

Jun 30, 2009 at 08:44 AM
sambr22 Posts 1 Registration date Thursday April 21, 2016 Status Member Last seen April 21, 2016  Apr 21, 2016 at 05:24 AM
sambr22 Posts 1 Registration date Thursday April 21, 2016 Status Member Last seen April 21, 2016  Apr 21, 2016 at 05:24 AM
Related:
 Count the number of times a value appears in a column
 Excel count how many times a value appears in a column  Best answers
 How to count the number of times a value appears in a column  Best answers
 You've tried to log in too many times. to protect your account, a temporary block has been placed on logging in. please try again later. ✓  Facebook Forum
 Count if cell contains number  Excel Forum
 You have guessed too many times ✓  WhatsApp Forum
 The system time is invalid. this may be a result of a loss in battery power ✓  CPU & Desktop Forum
 It appears that call of duty did not quit  Call of Duty (CoD) Forum
3 responses
mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
165
Jul 1, 2009 at 01:38 AM
Jul 1, 2009 at 01:38 AM
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))