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

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

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

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

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

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 -