1. ## Parenthesis issue

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))

2. The COUNTIF formula will return a single value to the sum range of the SUMIF formula, however this should be a range.

3. Originally Posted by CheshireCat
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

4. Im pretty sure the parenthesis is causing a problem..........can anyone please tell me where should i insert the parenthesis???

5. 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

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

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.

8. Originally Posted by eisayev
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?

isnt criteri always single cell?
yes, mostly criteria is a single cell. but there u need a range

10. I couldnt understand why countif function is in the sumif"s sumrange part. countif doesnt give you any range

#### Posting Permissions

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