Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values in sheets and putting them on a summery
I have read over the several post regarding the adding of values on one sheet
to provide it in a summery sheet but all efforts have failed to work it out. The workbook contains a summery sheet, which is named summery but represents sheet1. The following sheets are then labelled with month dates for Example JAN 08, etc. What I am trying to figure out is how to add different columns up (for example B column) which has the word "completed" entered numerous time and place the total of B on the summery sheet and the same for column C, etc!! To give a total of the different fields across the columns for each month. So in the end the summery sheet will have a total of each Month, with the total of each specified column total. With the result providing a 12 month over view of fields that have been completed for each month. ANY help would be great!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values in sheets and putting them on a summery
I'm not exactly sure what you are dealing with there, but did you consider
using a Pivot Table? http://www.contextures.com/xlPivotPlayPLUS01.html http://peltiertech.com/Excel/Pivots/pivottables.htm Regards, Ryan--- -- RyGuy "Garry55" wrote: I have read over the several post regarding the adding of values on one sheet to provide it in a summery sheet but all efforts have failed to work it out. The workbook contains a summery sheet, which is named summery but represents sheet1. The following sheets are then labelled with month dates for Example JAN 08, etc. What I am trying to figure out is how to add different columns up (for example B column) which has the word "completed" entered numerous time and place the total of B on the summery sheet and the same for column C, etc!! To give a total of the different fields across the columns for each month. So in the end the summery sheet will have a total of each Month, with the total of each specified column total. With the result providing a 12 month over view of fields that have been completed for each month. ANY help would be great!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding values in sheets and putting them on a summery
Maybe something like this using INDIRECT would help to start you off
Let's say your sheets are named as: JAN 08, FEB 08, etc all sheets identically structured In the sheet: Summary, you could enter in C1 across, the sheetnames: JAN 08, FEB 08, etc (Enter these sheetnames as **text**, with a preceding apostrophe. Or pre-format C1 across as TEXT before keying it in. The sheetnames must match exactly with what's on the tabs, except for case And in B2 down, you could enter the desired col ref strings, eg: B:B, E:E, Z:Z, etc Then you could put this in C2: =SUM(INDIRECT("'"&C$1&"'!"&$B2)) and simply copy C2 across/fill down to populate the required sums from each tab's col B, col E, col Z, etc -- Max Singapore http://savefile.com/projects/236895 Downloads:18,300 Files:361 Subscribers:58 xdemechanik --- "Garry55" wrote: I have read over the several post regarding the adding of values on one sheet to provide it in a summery sheet but all efforts have failed to work it out. The workbook contains a summery sheet, which is named summery but represents sheet1. The following sheets are then labelled with month dates for Example JAN 08, etc. What I am trying to figure out is how to add different columns up (for example B column) which has the word "completed" entered numerous time and place the total of B on the summery sheet and the same for column C, etc!! To give a total of the different fields across the columns for each month. So in the end the summery sheet will have a total of each Month, with the total of each specified column total. With the result providing a 12 month over view of fields that have been completed for each month. ANY help would be great!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
monthly & quarterly Summery | Excel Discussion (Misc queries) | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
Excel keeps putting .xls] on my sheets and then I get an error | Excel Discussion (Misc queries) | |||
why does the calculation summery not change | Excel Discussion (Misc queries) | |||
How to creat summery file form many xl files? | Excel Worksheet Functions |