Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel cells spanning multiple printed pages | Excel Discussion (Misc queries) | |||
Range Spanning worksheets | Excel Worksheet Functions | |||
Ranges spanning worksheets | Excel Worksheet Functions | |||
Time calculation (in hh.mm) spanning more than one day | Excel Discussion (Misc queries) | |||
Entering data and spanning adjacent cells | Excel Discussion (Misc queries) |