Help with Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

grobertson - 20 Jul 2006 10:26 GMT

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

Reply to this Message

Special-K - 20 Jul 2006 10:54 GMT

Try

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

--
Special-

Reply to this Message

Don Guillett - 20 Jul 2006 12:58 GMT

Or if your months are actually dates formatted as mmmm

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

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

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

Reply to this Message