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. I couldnt understand why countif function is in the sumif"s sumrange part. countif doesnt give you any range

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

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

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

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

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

Page 1 of 2 1 2 Last

#### Posting Permissions

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