If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to perform "ifcount" in many sheets
I have a column, lets call pipeID (this contains 1500 pipeID) these data are
stored in sheet called "original". I have run a program for damagae analysis of these pipes, 50 times (for 50 scenarios). I have stroed result for each run in separate sheet. I have 50 sheets named:run1, run2, …, run50. In each sheet I have following data: PipeID of broken pipes and pipeID of leaked pipes. (In each run only few pipe out of 1500 pipes are broken or leaked, relativley a very small number of pipes) Now I want to perform a countif command over these 50 sheets separetly for leaks and breaks, and write result in "original sheet" in front of each PipeID for leaks and break separately.  Solution one) Easiest way I can perform countif for each sheet separately and write result in "original" sheet, then I can add these 50 cells. Better solution) Question one: I was wondering if it is possible to perform countif command over 50 sheets at ones. Question 2) My method is very straight forward and easy but with no talent on it. I would like to know if there is any smarter way to count number of cells over more than one sheet? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan |
#2
|
|||
|
|||
How to perform "ifcount" in many sheets
There is an active thread in .misc
Khoshravan wrote: I have a column, lets call pipeID (this contains 1500 pipeID) these data are stored in sheet called "original". I have run a program for damagae analysis of these pipes, 50 times (for 50 scenarios). I have stroed result for each run in separate sheet. I have 50 sheets named:run1, run2, …, run50. In each sheet I have following data: PipeID of broken pipes and pipeID of leaked pipes. (In each run only few pipe out of 1500 pipes are broken or leaked, relativley a very small number of pipes) Now I want to perform a countif command over these 50 sheets separetly for leaks and breaks, and write result in "original sheet" in front of each PipeID for leaks and break separately.  Solution one) Easiest way I can perform countif for each sheet separately and write result in "original" sheet, then I can add these 50 cells. Better solution) Question one: I was wondering if it is possible to perform countif command over 50 sheets at ones. Question 2) My method is very straight forward and easy but with no talent on it. I would like to know if there is any smarter way to count number of cells over more than one sheet? -- Rasoul Khoshravan Azar Civil Engineer, Osaka, Japan -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macros-creating new sheets | Bonbon | Worksheet Functions | 3 | February 17th, 2006 09:44 AM |
Does excel recognise names rather than cells? | Sue | Worksheet Functions | 9 | May 22nd, 2005 04:51 AM |
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | RICHARD | Worksheet Functions | 1 | March 15th, 2005 05:49 PM |
Need help summing sheets based on a variable | Leatherfoot | Worksheet Functions | 5 | July 6th, 2004 01:42 PM |
Summing excel spread sheets | Jim Knaggs | Worksheet Functions | 2 | June 24th, 2004 01:05 AM |