| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| CountIf for a range with multiple criteria | Excel Discussion (Misc queries) | |||
| How do I put a date range in the criteria of a countif formula? | Excel Discussion (Misc queries) | |||
| SUM(COUNTIF(range,NOT Criteria)) | Excel Worksheet Functions | |||
| use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Linear Mode
