Hello,

I am having an issue with a couple of formulas. In F7 I have the following formula:
=(5*(LEFT('May 2015 PPA Counts'!M7,(FIND("/",'May 2015 PPA Counts'!M7)-1)))) which returns a value of 25 which is correct.

Then in G7 I have the following formula
=COUNTIFS(CFS_SUB,"YES",LOS,">1",NO,VLOOKUP(B7,MP_Table,2,FALSE),PPA_YTD, ">25") which returns a value of 6 which is correct.

What I want to do is instead of use the >25 in the second formula is use >F7 but when I replace the 25 with F7, whose value is 25, the formula returns 0.

I'm sure it has to do with a reference error but I can't figure it out?

Thanks for the help!