View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garry55 Garry55 is offline
external usenet poster
 
Posts: 1
Default 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!!!