Countifs formula error!

**lenx.onor** · 02-16-2014, 12:20 PM

Hi,
I am trying to populate some results using countifs formula with multiple criterias. below is the formula am using and the last two criterias are dates

=COUNTIFS('Unproccessed CIT'!$B$5:$B$411,Summary!$A$4:$A$35,'Unproccessed CIT'!$G$11:$G$417,"<>"&"closed",'Unproccessed CIT'!$A$5:$A$38,">="&$C$2,'Unproccessed CIT'!$A$5:$A$38,"<="&Summary!$E$2)

Results:
#VALUE!

Please help

**AliGW** · 02-16-2014, 12:32 PM

Is it because 'unproccessed' (sic) is misspelt?

**Pepe Le Mokko** · 02-16-2014, 12:34 PM

Each additional range must have the same number of rows and columns as the criteria_range1 argument, which is not the case in your formula

**XOR LX** · 02-16-2014, 12:41 PM

Hi and welcome to the forum!

This function requires that the criteria ranges be of equal size. You have 4 such ranges (2 are in fact the same): 'Unproccessed CIT'!$B$5:$B$411 and 'Unproccessed CIT'!$G$11:$G$417 consist of 407 rows, whereas 'Unproccessed CIT'!$A$5:$A$38 consists of only 34.

What's more, your first criterion is not a single cell, but a range of cells (Summary!$A$4:$A$35). I think you should upload a sample workbook and explain precisely what it is you are trying to achieve.

Regards