Help with Formula

[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

[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"))

--
Don Guillett
SalesAid Software
[email protected]
"Special-K" <[email protected]> wrote
in message news:[email protected]...
>
> Try
>
> =SUMPRODUCT((A1:A154="January")*(B1:B154="Open"))
>
>
> --
> Special-K
>
>
> ------------------------------------------------------------------------
> Special-K's Profile:
> http://www.excelforum.com/member.php...fo&userid=7470
> View this thread: http://www.excelforum.com/showthread...hreadid=563188
>