Calculating formulas onto a Year End page.

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I have a workbook with 12 months of data and I want to transfer all data from
each month to create a year to date percentage in each category. How do I do
this?
 
Detail is sadly lacking for any meaningful guesses to be hazarded. That's why
you haven't got any responses so far. We don't know where to start in
responding. Illustrate by pasting some sample data. Are the "monthly" data
sheets identically structured? How are they named? Show us via an example or
two how the calcs should flow to derive the results for "year to date
percentage in each category". Etc.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
Sorry about that. All cells are the same on every sheet.

Year To Date Sheet:
Each column is identified with a certain category that is the same
information that I have on each sheet label Jan-Dec.

I need to obtain the year to date stats and compile it into a year to date
stat.

B2 = Sales
C2 = Liquor
D2 = Liquor Percentage (C2/B2)
E2 through M2 is other categories that just need the average from all 12
months.

Lisa
 
Back
Top