LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
monthly & quarterly Summery Narnimar Excel Discussion (Misc queries) 6 July 21st 08 02:54 PM
Adding numerical values based on multiple values in another column Kazmaniac Excel Worksheet Functions 6 April 4th 07 08:53 PM
Excel keeps putting .xls] on my sheets and then I get an error Michelle Excel Discussion (Misc queries) 1 August 2nd 06 12:38 PM
why does the calculation summery not change calculation summery does not change Excel Discussion (Misc queries) 3 May 9th 06 06:43 AM
How to creat summery file form many xl files? Brian Excel Worksheet Functions 1 March 27th 06 01:47 PM


All times are GMT +1. The time now is 12:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"