Parenthesis issue

**saadt** · 2012-10-04, 07:30 PM

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

**CheshireCat** · 2012-10-04, 07:41 PM

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

**eisayev** · 2012-10-04, 07:44 PM

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

**saadt** · 2012-10-04, 09:27 PM

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

**saadt** · 2012-10-04, 09:30 PM

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

**eisayev** · 2012-10-04, 09:37 PM

Originally Posted by saadt

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.

**saadt** · 2012-10-04, 09:39 PM

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

**saadt** · 2012-10-04, 09:40 PM

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?

**eisayev** · 2012-10-04, 09:43 PM

Originally Posted by saadt

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