Formular in multiple work sheets

  • Thread starter Thread starter BRANDON99
  • Start date Start date
B

BRANDON99

Hi

We sell shoes and use an excel worksheet to record itdividual stor
orders for pre season orders.
The styles are vertically down the sheet (100+), and the sizes ar
across the sheet.(14). In the final week of the sales period all th
orders are compiled and set to the factory. There could be 200
individual orders.

Is there a simple(quick way) to get a total for each size in eac
style, ie. automatically link the cells without having to do eac
incividually?

Many thanks

Stephe
 
If I understand you correctly, each store order has its own sheet and each
sheet is layed out the same.

Create a new blank sheet and call it "Start" and place the sheet just before
the first store order sheet. Then create another blank sheet and call it
"End" and place it after the last store order sheet.

Then on your totals sheet place the formula:

=sum(Start:End!A2)

which will sum all A2 cells on all sheets between the sheets Start and End.

Don Pistulka
 
Hi

Don's answer will work great if all of the sheets are exactly the same, ie
each size & style are in the same place - if not you might like to have a
look at the consolidation feature under the data menu. Ticking the two
boxes down the bottom of the consolidation screen before you select the
ranges to consolidate will allow styles & sizes to be matched & summed
together.

let us know how you go.

Cheers
JulieD
 
Back
Top