Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MS Excel 2010 { } function

    Hi,

    What is the function that puts { } around the function e.g. {=sum(if(A1:b10="Y:,AA1:AB10,0))}

    Thanks

    Mike

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    990
    Thanks
    56
    Thanked 105 Times in 90 Posts
    The curly brackets indicate that this is an ARRAY function, which you create by pressing CTRL SHIFT ENTER after typing it, instead of just ENTER.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Martin

Posting Permissions

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