 |
 | 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 / April 2007criteria in multiple columns
I am trying to get a count of rows where the date column has a specific date and a second column is marked with an "X". Example: Col F is a column of dates Col L is marked with an "X" by the end user if certain events have taken place. Please help. Try this: =SUMPRODUCT(--(F1:F10=DATE(2007,1,1)),--(L1:L10="X")) Or, use cells to hold the criteria: A1 = some date like 1/1/2007 B1 = X =SUMPRODUCT(--(F1:F10=A1),--(L1:L10=B1)) Biff >I am trying to get a count of rows where the date column has a specific >date [quoted text clipped - 5 lines] > > Please help. The =SUMPRODUCT works perfectly. You are the best. Thank you so much! > Try this: > [quoted text clipped - 18 lines] > > > > Please help. You're welcome. Thanks for the feedback! Biff > The =SUMPRODUCT works perfectly. You are the best. Thank you so much! > [quoted text clipped - 21 lines] >> > >> > Please help. Can you please tell me how to make this work with a date range (ex: 3/1/07 - 3/31/07) also? > Try this: > [quoted text clipped - 18 lines] > > > > Please help. Try one of these: =SUMPRODUCT(--(F1:F10>=DATE(2007,3,1)),--(F1:F10<=DATE(2007,3,31)),--(L1:L10="X")) Or: A1 = start date 3/1/2007 B1 = end date 3/31/2007 C1 = X =SUMPRODUCT(--(F1:F10>=A1),--(F1:F10<=B1),--(L1:L10=C1)) Biff > Can you please tell me how to make this work with a date range (ex: > 3/1/07 - [quoted text clipped - 23 lines] >> > >> > Please help. Once again you are a lifesaver! Thanks > Try one of these: > [quoted text clipped - 37 lines] > >> > > >> > Please help. One way: =SUMPRODUCT(($F$2:$F$100=--"01-Jan-2007")*($L$2:$L$100="X"))  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > I am trying to get a count of rows where the date column has a specific date > and a second column is marked with an "X". [quoted text clipped - 4 lines] > > Please help. |
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.