View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

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.