I need a formula
 

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

I need a formula
 

=SUMPRODUCT((O1:O100=DATE(2009,1,1))*(D1:D100="Par amount"))


"Trev" wrote:

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

I need a formula
 

In article ,
Trev wrote:

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.

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

I need a formula
 

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.

"Teethless mama" wrote:

=SUMPRODUCT((O1:O100=DATE(2009,1,1))*(D1:D100="Par amount"))


"Trev" wrote:

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

I need a formula
 

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

=SUMPRODUCT((TEXT(O1:O100,"MMYYYY")=TEXT(E1,"MMYYY Y"))*(D1:D100="Paramount"))

If this post helps click Yes
---------------
Jacob Skaria


"Trev" wrote:

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

I need a formula
 

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

--
Domenic
Microsoft Excel MVP
www.xl-central.com
Your Quick Reference to Excel Solutions

In article ,
Trev wrote:

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.

"Teethless mama" wrote:

=SUMPRODUCT((O1:O100=DATE(2009,1,1))*(D1:D100="Par amount"))


"Trev" wrote:

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