 |
 | 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 / General Excel Questions / May 2008SUMIF?
have a worksheet that is from external data set: SN,City,Date, SU,MO,TU,WE,TH,FR,SA, QTY ,[weeknum] I add a column to put WEEKNUM based on date. the dates are generally the past 13 weeks what i am wanting to do is, sum each QTY (quantity sold) for each SN (store number) by WEEKNUM and place results on another ws in same book where the SN would be COL headings and the weeks in the ROW s. thanks Post sample data. Try Sumproduct may be you can try =sumproduct(--(SN-range=sn)*--(weeknum-range=weekno),qtrrange) Hope this is useful to you Best wishes Sreedhar > have a worksheet that is from external data set: > SN,City,Date, SU,MO,TU,WE,TH,FR,SA, QTY ,[weeknum] [quoted text clipped - 5 lines] > where the SN would be COL headings and the weeks in the ROW s. > thanks thx, i setup different query to external data that gives me the correct data w/o any further interevention > Post sample data. > Try Sumproduct [quoted text clipped - 13 lines] > > where the SN would be COL headings and the weeks in the ROW s. > > thanks |
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.