| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count no of cells containing data for more than one criteria
Hi
Is there any formula, which can retrieve the count of cells in a range which contains some specific words. EG: A column contains rose,jasmine,flower,dress,color etc. From this list of data i need to get the number of cells contains rose, jasmine and color. Thanks in advance Regards jasmine |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count no of cells containing data for more than one criteria
One way:
=SUM(COUNTIF(A:A,{"rose","jasmine","color"})) In article , jasmine wrote: Hi Is there any formula, which can retrieve the count of cells in a range which contains some specific words. EG: A column contains rose,jasmine,flower,dress,color etc. From this list of data i need to get the number of cells contains rose, jasmine and color. Thanks in advance Regards jasmine |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count no of cells containing data for more than one criteria
=SUMPRODUCT(--(A1:A1000={"rose","jasmine","color"}))
"jasmine" wrote: Hi Is there any formula, which can retrieve the count of cells in a range which contains some specific words. EG: A column contains rose,jasmine,flower,dress,color etc. From this list of data i need to get the number of cells contains rose, jasmine and color. Thanks in advance Regards jasmine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Cells that meet Criteria | Excel Worksheet Functions | |||
| How do I count data with criteria from two separate columns in exc | Excel Worksheet Functions | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Count cells with data | New Users to Excel | |||
Linear Mode
