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,