Consulting

Results 1 to 3 of 3

Thread: Excel formula syntax

  1. #1
    VBAX Regular
    Joined
    Jul 2004
    Location
    Sykesville, Maryland
    Posts
    53
    Location

    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

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,262
    Location
    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.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Regular
    Joined
    Jul 2004
    Location
    Sykesville, Maryland
    Posts
    53
    Location
    Quote Originally Posted by Bob Phillips View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •