I need a formula

  • Thread starter Thread starter Trev
  • Start date Start date
T

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
 
Trev said:
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
Click to expand...


=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.
 
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.
 
Below will count all for the month of date specified in cell E1

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

If this post helps click Yes
 
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))
 
Back
Top