=Count(IF(And... Function will not bring in values.

Hi,

I am trying to use "CountIfs" across two sheets and I know it will not work if it is closed. So I am trying to use:

{=COUNT(IF(AND('[2014 Benefits Abeyance Log (USE THIS ONE).xlsm]2014 LOG - Current (2)'!$FL$6:$FL$719>10,'[2014 Benefits Abeyance Log (USE THIS ONE).xlsm]2014 LOG - Current (2)'!$FL$6:$FL$719<15),1))}

But it return a value of "0"

When I do {=COUNT(IF('[2014 Benefits Abeyance Log (USE THIS ONE).xlsm]2014 LOG - Current (2)'!$FL$6:$FL$719>10,1))}

I get 423.

I want to get values more then or equal to 10 but less then 15 and moving up until 60 doing that.


Thanks,

Also, instead of the Array entered formula, try countifS

=COUNTIFS($FL$6:$FL$719,">10",$FL$6:$FL$719,"<15")

OMG! Worked Beautifully, Thanks Jonmo!!!

You're welcome.