| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif-multiple conditions
Is there a way to count the number of something if the condition that you're
counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif-multiple conditions
Try one of these:
=COUNTIF(B2:B200,"Data")+COUNTIF(B2:B200,"Function ") =SUM(COUNTIF(B2:B200,{"Data","Function"})) Biff "miteeka" wrote in message ... Is there a way to count the number of something if the condition that you're counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif-multiple conditions
maybe someone will have a better or shorter answer, but I found this works
=SUMPRODUCT(ISNUMBER(FIND("Data", B2:B200))*ISNUMBER(FIND("Function", B2:B200))*1) "miteeka" wrote: Is there a way to count the number of something if the condition that you're counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif-multiple conditions
I think I might have misunderstood the question. The formula I gave will give
the count of cells that has both "Data" and "Function". This one will give the count of cells that has "Data" or "Function". It's an array formula, so enter by pressing CTRL+SHIFT+ENTER =SUMPRODUCT(IF(ISNUMBER(FIND("Data", B2:B200)), TRUE, IF(ISNUMBER(FIND("Function", B2:B200)), TRUE, FALSE))*1) "Vergel Adriano" wrote: maybe someone will have a better or shorter answer, but I found this works =SUMPRODUCT(ISNUMBER(FIND("Data", B2:B200))*ISNUMBER(FIND("Function", B2:B200))*1) "miteeka" wrote: Is there a way to count the number of something if the condition that you're counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif-multiple conditions
How about:
=SUMPRODUCT((B2:B200="Data")+(B2:B200="Function")) Hope this helps. Pete On Mar 9, 7:02 pm, Vergel Adriano wrote: maybe someone will have a better or shorter answer, but I found this works =SUMPRODUCT(ISNUMBER(FIND("Data", B2:B200))*ISNUMBER(FIND("Function", B2:B200))*1) "miteeka" wrote: Is there a way to count the number of something if the condition that you're counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countif-multiple conditions
=COUNTIF(B2:B200,"Data")+COUNTIF(B2:B200,"Function ")
-- Gary''s Student gsnu200709 "miteeka" wrote: Is there a way to count the number of something if the condition that you're counting is more than one string of values? ie. I want to count the number of times "Data" or "Function" occurs in a given cell I've tried =countif(B2:B200,"Data","Function") but it doesn't work. Any suggestions? thanks -- miteeka |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif with Multiple Not Conditions | Excel Discussion (Misc queries) | |||
| COUNTIF with multiple conditions | Excel Discussion (Misc queries) | |||
| Multiple conditions on a countif | Excel Worksheet Functions | |||
| COUNTIF Multiple Conditions | Excel Discussion (Misc queries) | |||
| COUNTIF - multiple conditions | Excel Worksheet Functions | |||
Hybrid Mode
