LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Sum of cells spanning several worksheets

I have a workbook that will have a varying number of
worksheets. The worksheet names will be "list (1)"
thru "list (xx)". Each worksheet has several cells that
that use "conditional sum" function to total quantities of
items based defined conditions.

I'd like to have a place on "list (1)" that will provide
total quantities that span all "lists", but I'm not sure
where to start.

I think I want to count the number of worksheets
named "list (*)", then, if "list (4)" exists, add the
value of the specific cell, if not, add zero. Am I on the
right track, or is there a better way? Can someone show
how to get started? Point me in the right direction and
I'll run with it.

THANKS!
Rich
 
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
Excel cells spanning multiple printed pages Brian B[_2_] Excel Discussion (Misc queries) 2 January 9th 08 02:33 PM
Range Spanning worksheets RD Wirr Excel Worksheet Functions 5 November 28th 06 04:08 PM
Ranges spanning worksheets RD Wirr Excel Worksheet Functions 0 November 22nd 06 07:04 AM
Time calculation (in hh.mm) spanning more than one day dtencza Excel Discussion (Misc queries) 8 August 16th 05 09:49 PM
Entering data and spanning adjacent cells QuartetmanIA Excel Discussion (Misc queries) 8 July 11th 05 04:44 PM


All times are GMT +1. The time now is 05:16 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"