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