Counting if multiple criteria are met

[herbie000]

I tried searching but was unable to find anything. I need to be able to count if I1:I3000 cells have yes in them and then if b1:b3000 are either Bison or Dbison. The current formula I have will only count the Bison and not Dbison.

=COUNTIFS(B1:B3100,{"Bison","Dbison"},I1:I3100,"Yes")

Any help would be greatly appreciated!

I am using the 2013 version.

[Tony Valko]

Like this...

=SUM(COUNTIFS(B1:B3100,{"Bison","Dbison"},I1:I3100,"Yes"))

[Jonmo1]

Withdrawn, misunderstood.

[herbie000]

Thanks much! I never thought of using =Sum.

[Tony Valko]

You're welcome. Thanks for the feedback!