All the formulas in excel can reference a different worksheet or even a
different file. You don't have to learn how to correctly format those
formulas, as Excel will do it for you. Try this: on your SheetB, in a new
cell start to type in a formula such as:

=COUNT(

then click on another sheet and select a range of cells on that sheet.
Excel will insert the sheet name for you in front of that range. Try it
again with a second file open and you will see the format that Excel uses to
reference another sheet in another file.

But you can't do it with a Tab . . . because that is a diet drink from the
early 70's. ;-)

HTH

"Dan the Man" wrote:

I have a question?

Is there a formula that I can use which references a different "tab" on my
spreadsheet.

For example if on sheet 1 (which of named New Rules) I have dates in which
clients were admitted to our treatment program. Also on sheet one, I list
their diagnoses (e.g depression, anxiety, etc).

On sheet 2 (which I nammed QA Data) I want to list "stats only". For
example, cell A1 on the QA Data sheet may list the total number of clients in
2007, and another cell may list a break out of diagnoses. Again, the raw data
for this information (name of client, admission date, diagnosis) is on sheet
1 (New Rules), but I want to use sheet 2 (QA Data) to tally the various stats
that I desire (a tab dedicated to stas).

I just didn't know if you can write Excel formula on one sheet askinig to
capture information from another sheet. The only thing I know how to do is to
"link data" between sheets, but I don't want to do that.

Thanks for any suggestions!

Dan