Code:

`=COUNTIFS(C6:C2600,"<=90",C6:C2600,">=30")`

My other criteria needs to be IF the cell in column A contains "NEW" or "OPEN", then give me the count of everything between 30&90.

You should upgrade or use an alternative browser.

- Thread starter Nu2Java
- Start date

Code:

`=COUNTIFS(C6:C2600,"<=90",C6:C2600,">=30")`

My other criteria needs to be IF the cell in column A contains "NEW" or "OPEN", then give me the count of everything between 30&90.

Code:

`=IF(OR(B6:B3000="New",B6:B3000="Open"),COUNTIFS(O6:O3000,"<=90",O6:O3000,">=30"),"")`

Code:

`=COUNTIFS($H$6:$H$3700,"",$B$6:$B$3700, X4, $O$6:$O3700,">=30",$O$6:$O$3700,"<=90")`

Details on this are as follows and my criteria is a bit changed now: If cell in Column H is blank (means no date was given) AND cell in Column B contains "New" or "Open" AND cell in Column O is greater than 30 and less then 90 (which is number of days old) then give me that total count.

Thanks for your help @pecoflyer ... I am getting a 'Too few arguments' error when applying it.

Maybe,Thanks for your help @pecoflyer ... I am getting a 'Too few arguments' error when applying it.

=sum(countifs($B$6:$B$3700,{"new","open"},$H$6:$H$3700,"",$O$6:$O3700,">=30",$O$6:$O$3700,"<=90"))

Yep, replace the = sign with a commaThanks for your help @pecoflyer ... I am getting a 'Too few arguments' error when applying it.