1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

need help in excel

Discussion in 'Other PC Software' started by vini, 2012/06/11.

  1. 2012/06/11
    vini

    vini Inactive Thread Starter

    Joined:
    2012/06/11
    Messages:
    1
    Likes Received:
    0
    What does '$j:$j' mean here:
    =SUMIF(sheet2!$H:$H,sheet1!$d3,sheet2!$J$J)


    vinita
     
    vini,
    #1
  2. 2012/06/12
    Arie

    Arie Administrator Administrator Staff

    Joined:
    2001/12/27
    Messages:
    15,174
    Likes Received:
    412
    Arie,
    #2


  3. to hide this advert.

  4. 2012/06/12
    dnmacleod

    dnmacleod Well-Known Member

    Joined:
    2009/05/16
    Messages:
    419
    Likes Received:
    58
    It's actually an error because it doesn't have a : between the 2 $Js. If it was sheet2!$J:$J, it would mean sheet 2 column J.
     
    Last edited: 2012/06/12
    dnmacleod,
    #3
  5. 2012/06/18
    alanrf

    alanrf Well-Known Member

    Joined:
    2004/03/05
    Messages:
    282
    Likes Received:
    8
    The $ prefix indicates that this is an 'absolute' value. Check out the Excel online Help file for more details.
     
    alanrf,
    #4

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...