| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Making COUNTIF conditional on the value in another field
HELP! I am trying to count the number of times a number appears in a field,
conditional upon it being a certain number in a different field. This is tracking survey response data for different categories of services, eg; CE (Careers & Employment), PC (Personal Counselling). Eg; I need to know the number of times a "1" (Very dissatisfied) has been recorded for a particular question for surveys completed under the Careers & Employment category. Categories are recorded as abbrieviated (CE) in Column A. SO, I want to record in cell B15 the number of times that the number "1" appears in a set of data in cells B4:B38, ONLY when the corresponding cell in A on the same row has the letters "CE" in it. Can anyone help? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a cell a search/find field | Excel Discussion (Misc queries) | |||
| Making a field value append a hyperlink | Excel Discussion (Misc queries) | |||
| Making COUNTIF update in real time | Excel Worksheet Functions | |||
| Making one field equal 2 others | Excel Worksheet Functions | |||
| What is a field name in excel when making a pivot table? | Excel Discussion (Misc queries) | |||
Threaded Mode
