Countif with date range criteria
 

I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007

Countif with date range criteria
 

=SUMPRODUCT(--(D2:D5000<""),--(month(M2:M5000)=5),--(year(M2:M5000)=2007))

HTH,
Paul

--

"luisi" wrote in message
...
I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007

Countif with date range criteria
 

Assuming you have dates in column M:

=SUMPRODUCT((D2:D5000<"")*(MONTH(M2:M5000)=5)*(YE AR(M2:M5000)=2007))

Hope this helps.

Pete

On Mar 28, 4:18*pm, luisi wrote:
I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007

Countif with date range criteria
 

=SUMPRODUCT(--(MONTH(M2:M5000)=5),--(YEAR(M2:M5000)=2007),--(D2:D5000<""))

--
Gary''s Student - gsnu200776


"luisi" wrote:

I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007

Countif with date range criteria
 

Perfect. Thanks guys, I orginally got most of it but I'm still shaky on
quotation marks and parathesis!

"Pete_UK" wrote:

Assuming you have dates in column M:

=SUMPRODUCT((D2:D5000<"")*(MONTH(M2:M5000)=5)*(YE AR(M2:M5000)=2007))

Hope this helps.

Pete

On Mar 28, 4:18 pm, luisi wrote:
I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007

Countif with date range criteria
 

Thanks for feeding back , Luisi.

Put each condition in brackets, and either use the double-unary -- and
separate the terms with a comma, or use the asterisk between terms as
I have.

Pete

On Mar 28, 5:01*pm, luisi wrote:
Perfect. Thanks guys, I orginally got most of it but I'm still shaky on
quotation marks and parathesis!



"Pete_UK" wrote:
Assuming you have dates in column M:

=SUMPRODUCT((D2:D5000<"")*(MONTH(M2:M5000)=5)*(YE AR(M2:M5000)=2007))

Hope this helps.

Pete

On Mar 28, 4:18 pm, luisi wrote:
I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck
(syntax maybe???).

I'm trying to count the nonblank cells from D2:D5000 with the following
criteria.

Month in column M (M2:M5000)=5
Year in column M (M2:M5000)=2007- Hide quoted text -

- Show quoted text -