Home |
Search |
Today's Posts |
#1
|
|||
|
|||
MS Excel Question
Is there any way to use an IF FUNCTION (or any derivative such as COUNTIF)
with 3D cell (mulitple worksheets) references? I am trying to retrieve/perform operations on data from mulitple worksheets within excel. I would like to do this from one page at the end rather than having to use the IF function on each individual page and then collecting those results on the last page. Any help would be much appreciated. |
#2
|
|||
|
|||
Hi!
Why don't you tell us exactly what you're wanting to do, in detail. For instance: I want to count the number of times "Yes" appears in A1:A100 on all 25 worksheets. In the meantime, the answer to your question is yes, maybe, it depends! Biff "STIK" wrote in message ... Is there any way to use an IF FUNCTION (or any derivative such as COUNTIF) with 3D cell (mulitple worksheets) references? I am trying to retrieve/perform operations on data from mulitple worksheets within excel. I would like to do this from one page at the end rather than having to use the IF function on each individual page and then collecting those results on the last page. Any help would be much appreciated. |
#3
|
|||
|
|||
For a possible technique see
http://tinyurl.com/a5wyg http://tinyurl.com/9sxvs -- Regards, Peo Sjoblom "STIK" wrote in message ... Is there any way to use an IF FUNCTION (or any derivative such as COUNTIF) with 3D cell (mulitple worksheets) references? I am trying to retrieve/perform operations on data from mulitple worksheets within excel. I would like to do this from one page at the end rather than having to use the IF function on each individual page and then collecting those results on the last page. Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Excel chart-y axis title question | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Excel Question | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |