| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMIF?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF?
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 "reno" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMIF?
thx, i setup different query to external data that gives me the correct data
w/o any further interevention "yshridhar" wrote: 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 "reno" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
| SumIf | Excel Worksheet Functions | |||
| Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
