Counting with Conditions

[MiriBella]

I have the D2:13 columen with "open" and "mod". I have my F2:F13 column with "yes" and "no".

I want F14 to add my "yes" in column F only if coumnd D has "open".

D F
mod no
open yes
open yes
mod yes

So F14 should equal 2.

Can this be done?

[Ron Coderre]

Try this regular formula

Please Login or Register  to view this content.

Is that something you can work with?

[Miraun]

yep, Countifs
=COUNTIFS(D2:D14,"Open",F2:F14,"Yes")

[MiriBella]

It worked!!!! Thank you!!!!!!!