 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2008Countif 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 =SUMPRODUCT(--(D2:D5000<>""),--(month(M2:M5000)=5),--(year(M2:M5000)=2007)) HTH, Paul > I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck > (syntax maybe???). [quoted text clipped - 4 lines] > Month in column M (M2:M5000)=5 > Year in column M (M2:M5000)=2007 Assuming you have dates in column M: =SUMPRODUCT((D2:D5000<>"")*(MONTH(M2:M5000)=5)*(YEAR(M2:M5000)=2007)) Hope this helps. Pete > I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck > (syntax maybe???). [quoted text clipped - 4 lines] > Month in column M (M2:M5000)=5 > Year in column M (M2:M5000)=2007 Perfect. Thanks guys, I orginally got most of it but I'm still shaky on quotation marks and parathesis! > Assuming you have dates in column M: > [quoted text clipped - 12 lines] > > Month in column M (M2:M5000)=5 > > Year in column M (M2:M5000)=2007 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 > Perfect. Thanks guys, I orginally got most of it but I'm still shaky on > quotation marks and parathesis! [quoted text clipped - 17 lines] > > - Show quoted text - =SUMPRODUCT(--(MONTH(M2:M5000)=5),--(YEAR(M2:M5000)=2007),--(D2:D5000<>""))  SignatureGary''s Student - gsnu200776 > I'm trying to come up with a SUMPRODUCT or COUNTIF Equation with no luck > (syntax maybe???). [quoted text clipped - 4 lines] > Month in column M (M2:M5000)=5 > Year in column M (M2:M5000)=2007 |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.