Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Thread: Parenthesis issue

  1. #1
    Seeker saadt's Avatar
    Join Date
    Sep 2012
    Posts
    13
    Articles
    0
    Excel Version
    2010

    Parenthesis issue



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can anyone pleas check the following formula and tell me why am I getting missing parenthesis errorr?

    =SUMIF(MAIN!$B$8:$B$1048576,'people count by hour'!$J$2,COUNTIF(MAIN!$GD$12:$GD$1048576,'people count by hour'!$A$4))


    Would appreciate your help

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    The COUNTIF formula will return a single value to the sum range of the SUMIF formula, however this should be a range.

  3. #3
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    I couldnt understand why countif function is in the sumif"s sumrange part. countif doesnt give you any range

  4. #4
    Seeker saadt's Avatar
    Join Date
    Sep 2012
    Posts
    13
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by CheshireCat View Post
    The COUNTIF formula will return a single value to the sum range of the SUMIF formula, however this should be a range.
    yes this is a range. Criteria is just one cell which will move as i drag the formula down to other cell

  5. #5
    Seeker saadt's Avatar
    Join Date
    Sep 2012
    Posts
    13
    Articles
    0
    Excel Version
    2010
    Im pretty sure the parenthesis is causing a problem..........can anyone please tell me where should i insert the parenthesis???

  6. #6
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Quote Originally Posted by saadt View Post
    yes this is a range. Criteria is just one cell which will move as i drag the formula down to other cell
    I dont think so, especially when your criteria (people count by hour'!$A$4) is a single cell. I hope anybody else will able to figure it out.

  7. #7
    Seeker saadt's Avatar
    Join Date
    Sep 2012
    Posts
    13
    Articles
    0
    Excel Version
    2010
    the reason why i am putting count if in the sum range of sum function because I dont want to add similar cells..........i rather want a count of similar cells.............like if A is repeating 5 times.......i want number 5 instead of sum of all the A's

  8. #8
    Seeker saadt's Avatar
    Join Date
    Sep 2012
    Posts
    13
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by eisayev View Post
    I dont think so, especially when your criteria (people count by hour'!$A$4) is a single cell. I hope anybody else will able to figure it out.
    isnt criteri always single cell?

  9. #9
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Quote Originally Posted by saadt View Post
    the reason why i am putting count if in the sum range of sum function because I dont want to add similar cells..........i rather want a count of similar cells.............like if A is repeating 5 times.......i want number 5 instead of sum of all the A's
    select the range, let the sumif function sum A 5 times. then subtract it to countif

  10. #10
    Acolyte eisayev's Avatar
    Join Date
    Oct 2012
    Location
    Baku, Azerbaijan
    Posts
    33
    Articles
    0
    Quote Originally Posted by saadt View Post
    isnt criteri always single cell?
    yes, mostly criteria is a single cell. but there u need a range

Page 1 of 2 1 2 LastLast

Posting Permissions

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