Sum with multiple different criteria

[gorillawar]

Hello,

I have one range I am trying to count the occurrence of aword, based on two other rows criteria. Probably better explain with an example.
A1:A5 contains the word “Closed” or “Open” I want to counthow many time the word “Open” is present, based off of the two following rowsbeing true.
B1:B5 contain dates ranging across different months. I wantto only count the “Open” words if the date is the first 6 months in the year.
C1:C5 is a counting formula the is related to a few otherthings, but I also want it to only count those “Open” words if this number isgreater than, or equal to 1.

I have tried to do this myself, but I assume it iscompletely wrong
=COUNTIF((A1:A5,"Open")*(MONTH(B1:B5)>=6)*(C1:C5>=1))

Any help is greatly appreciated!

Thanks,

 

[gorillawar]

**** perfect, thank you!