SUMIF?

[reno]

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

 

[yshridhar]

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]

thx, i setup different query to external data that gives me the correct data
w/o any further interevention

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]
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