Hello,
I conducted a survey in which some questions allowed more than one response.
Using Excel - I'm trying to count the number of times a certain value appears in a column even if there are multiple values in the same cell.
For example: A respondant may have selected answer a, b, d for question 5 (all 3 of these would be in the same cell), while another respondant may have selected answer a, c, d for the same question. For that entire column, I want to know how many times respondants selected "a" regardless of any other selections made.
COUNTIF only counts this response in that column if "a" was the only option selected.
Please help!
Thanks
Configuration: Windows XP Internet Explorer 6.0
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 ....
=SUM(IF(ISERROR(SEARCH("*a*",A1:A10,1)),0,1))
Never ashamed to get or give Advise. Muhammad Mubashir Aziz , Lodhran, Pakistan |
Count number Count number of values appear excel Count number of values without repeating excel Count text in one cell only if certain data appears in another cell Count the number of red format cells in excel Countif display value Excel count number of unique text values Excel count the number of times a value appears Excel count unique values Excel formulas test if value in one column is in another column Find even and odd number in c-language through if and else statement Formula to count number of hours and minutes of work How to change colour of cell if value equals another cell How to count number of cells containing a specific number in excel If and count if function combination excel formula Ms excel check if number of cells equal a particular value Ms excel pulling cell number value Validation appears if an if statement is true in excel