Adding values in sheets and putting them on a summery

[Garry55]

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!!!

 

[ryguy7272]

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---

 

[Max]

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