Help with Formula

[Guest]

Hi,
Just need help with a quick formula.

Column A contains the Month (i.e. January, February, March etc..)
Column B contains either "Open" or "Closed"

I currently have the following formula in column C :-
=COUNTIF(B1:B54,"Open")

This counts how many cells in column B contain "Open"

I would like a formula in the cell that say's countif A = January and B =
Open.

Thanks

 

[Special-K]

Try

=SUMPRODUCT((A1:A154="January")*(B1:B154="Open")

 

[Don Guillett]

Or if your months are actually dates formatted as mmmm

=SUMPRODUCT((month(A1:A154)=1)*(B1:B154="Open"))