I need a formula

[Trev]

I need to count all the entries I make each month with Paramount for the
project name. Example in column "O" I enter a closing date and in column "D"
I have the project name. If column O= 1/1/09 and column D= Paramount it will
count it. I am trying to get the count of how many projects are closed each
month.
Thanks

 

[Teethless mama]

=SUMPRODUCT((O1:O100=DATE(2009,1,1))*(D1100="Paramount"))

 

[Domenic]

I need to count all the entries I make each month with Paramount for the
project name. Example in column "O" I enter a closing date and in column "D"
I have the project name. If column O= 1/1/09 and column D= Paramount it will
count it. I am trying to get the count of how many projects are closed each
month.
Thanks

=SUMPRODUCT(--($D$2:$D$100="Paramount"),--($O$2:$O$100=DATE(2009,1,1)))

or

=SUMPRODUCT(--($D$2:$D$100=S2),--($O$2:$O$100=T2))

....where S2 contains Paramount and T2 contains 1/1/09. Adjust the
ranges, accordingly.

 

[Trev]

This is a start but the date needs to be any date in January not just the
1st. so if the closing is Paramount and happens anytime in January it will
count.

 

[Jacob Skaria]

Below will count all for the month of date specified in cell E1

=SUMPRODUCT((TEXT(O1:O100,"MMYYYY")=TEXT(E1,"MMYYYY"))*(D1100="Paramount"))

If this post helps click Yes

 

[Domenic]

Try...

=SUMPRODUCT(--($D$2:$D$100="Paramount"),--(MONTH($O$2:$O$100)=1))

If Column O can contain empty cells, which correspond to the values in
Column D that equal "Paramount", try the following instead...

=SUMPRODUCT(--($D$2:$D$100="Paramount"),--($O$2:$O$100<>""),--(MONTH($O$2
:$O$100)=1))