Excel formula syntax

I have a workbook with several worksheets. The data is in a worksheet titled "Raw Data".

I have several formulas that gather the information into counts. Here is an example"
=COUNTIFS($T$2:$T$130,"Baltimore, MD",$W$2:$W$130,"Winter")

What I am attemting, unsuccessfully, is to add another worksheet to the workbook that will contain all the data counts. I thought all I had to do to reference the "Raw Data" was to add 'Raw Data'! to the formula. This does not work. Can anyone tell me what I am doing wrong?
Thanks

That should work. Try putting that sheet qualifier in the formula before you add the extra sheet and see what you get.

After that, maybe post the workbook for us to see.

Quote:

---

Originally Posted by Bob Phillips

That should work. Try putting that sheet qualifier in the formula before you add the extra sheet and see what you get.

After that, maybe post the workbook for us to see.

---

Bob I figured it out. This is the correct syntax.

=COUNTIFS('Raw Data'!$T$2:$T$130,"Baltimore, MD",'Raw Data'!$W$2:$W$130,"Winter")

I had to put 'Raw Data'! before each criteria.
Thanks for your help.