| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating formulas onto a Year End page.
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? -- Lisa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating formulas onto a Year End page.
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 --- "Lisa" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating formulas onto a Year End page.
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 -- Lisa "Max" wrote: 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 --- "Lisa" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating formulas onto a Year End page.
Try a new posting. Include more detail in your new post.
I'm not able to suggest anything, sorry -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "Lisa" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating MAX, MIN & AVG for each year | Excel Worksheet Functions | |||
| Calculating quarters of a year. | Excel Worksheet Functions | |||
| Calculating year to date... | Excel Discussion (Misc queries) | |||
| Calculating by individual months of the year | Excel Discussion (Misc queries) | |||
| Calculating number of Saturday's in a Year | Excel Discussion (Misc queries) | |||
Linear Mode
