Help with Formula

G

grobertson

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
 
D

Don Guillett

Or if your months are actually dates formatted as mmmm

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