 |
 | 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 / May 2008complex function----Help!
I have a worksheet(1) that is setup as follows: Col A ColB ColC Item# Date Qty Worksheet(2) ColA ColB ColC ColD Item# Start Date End Date (result) I am trying to write a function that will look for info in cell A5 in worksheet 2 and find the info in column A in worksheet 1 check that the date in column B being between a date range and then returning a sum of the totals of the corresponding rows of column C in worksheet 1. I hope this makes sense..I'm not sure how else to explain it.  Signaturenarp you should use sumproduct. a sample: =sumproduct(--(a2:a100=g2)*(b2:b100>h2)*(b2:b100<i2),(c2:c100)) where: g2 contaim the item code that excel will check on column A h2 has the start date that will be check on column B I2 has the end date and column c has the values that you would like to sum. change the ranges as you need. hth Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > I have a worksheet(1) that is setup as follows: > Col A ColB ColC [quoted text clipped - 9 lines] > of the corresponding rows of column C in worksheet 1. I hope this makes > sense..I'm not sure how else to explain it. Thanks so much I'll try that. One other thing my boss wants---is there a way to set it up so that you can double click on the result cell and have another worksheet open with the info that it gathered like a pivot table does? Signaturenarp > you should use sumproduct. a sample: > [quoted text clipped - 24 lines] > > of the corresponding rows of column C in worksheet 1. I hope this makes > > sense..I'm not sure how else to explain it. Only in Pivot tables Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > Thanks so much I'll try that. One other thing my boss wants---is there a way > to set it up so that you can double click on the result cell and have another [quoted text clipped - 28 lines] > > > of the corresponding rows of column C in worksheet 1. I hope this makes > > > sense..I'm not sure how else to explain it. thanks again Signaturenarp > Only in Pivot tables > [quoted text clipped - 30 lines] > > > > of the corresponding rows of column C in worksheet 1. I hope this makes > > > > sense..I'm not sure how else to explain it. you are welcome Signatureregards from Brazil Thanks in advance for your feedback. Marcelo > thanks again > [quoted text clipped - 32 lines] > > > > > of the corresponding rows of column C in worksheet 1. I hope this makes > > > > > sense..I'm not sure how else to explain it. |
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.