SUMIF?

R

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
 
Y

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
 
R

reno

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

yshridhar said:
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 said:
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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change dates to a custom format via formula ... how to? 5
Custom date format for days ... again ... thx <g> 10
Chart Problems 0
Formula to give special date format but with addition? 3
Days of the week's special format (i.e., Mon = Mn, Tue = Tu ... Sat = Sa, Sun = Sn)? 1
Overlay Schedule Question 0
Show only specified columns 2
1-7 Columns, to find last column with figure in 3

Top