MS Excel Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting external data from multiple excel workbooks 2
Weekly Worksheets from others merged into one summary sheet 1
PivotTable Question 1
Lotus/Excel questions 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
lookup functions and text comparisons 1
How to autofill the same cell reference across multiple worksheet. 1
Excel VBA 1

Back
Top