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 -