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.

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.

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.