 |
 | 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 / New Users / October 2007sumproduct using a date range
this is the formula that I've used before but not needing dates so I'm having trouble. =SUMPRODUCT(--('PO Numbers'!$K$4:$K$240=17407),--('PO Numbers'!$A$4:$A$240=1/0/7),'PO Numbers'!$J$4:$J$240) I need it to calculate if column K = 17407 and if in column A the date is between 7/1/2007 to 7/31/2007 to pull the numbers in column J. So my attempt at that is the =1/0/07 in the formula above. someone help. One way: =SUMPRODUCT(--('PO Numbers'!$K$4:$K$240=17407), --('PO Numbers'!$A$4:$A$240>=DATE(2007,7,1)), --('PO Numbers'!$A$4:$A$240<=DATE(2007,7,31)), 'PO Numbers'!$J$4:$J$240) > this is the formula that I've used before but not needing dates so I'm having > trouble. [quoted text clipped - 6 lines] > > So my attempt at that is the =1/0/07 in the formula above. someone help. This returned a #REF error. > One way: > [quoted text clipped - 12 lines] > > > > So my attempt at that is the =1/0/07 in the formula above. someone help. Well, it's *your* sheet name, so make sure that there aren't any extra spaces/etc. in all of the sheet names... > This returned a #REF error. > [quoted text clipped - 3 lines] > > Numbers'!$A$4:$A$240>=DATE(2007,7,1)), --('PO > > Numbers'!$A$4:$A$240<=DATE(2007,7,31)), 'PO Numbers'!$J$4:$J$240)
|
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.