AM15 as defined works OK for me : what do you mean "if I use a normal number"
.... instead of what?

And AN15 isn't mentioned anywhere .. what's in it?


"Killer" wrote:

Hey guys need help on this formula as I keep getting a #REF! Error that won't
list what is required from cell AN15. The formulas below are as follow.

Cell C7
=IF(ROWS($1:1)<=COUNTA(B$15:B$47),INDEX(B$15:B$47, MATCH(LARGE(AM$15:AM$47-ROW(AM$15:AM$47)/10^10,ROWS($1:1)),AM$15:AM$47-ROW(AM$15:AM$47)/10^10,0)),"")

Cell E7
=IF(C7="","",INDEX(AM$15:AM$47,MATCH(C7,B$15:B$47, 0)))

Cell AM15
=COUNTIF(D15:AK15,"ˆš")+COUNTIF(D15:AK15,"P")*0.5 &" -
"&COUNTIF(D15:AK15,"X*")+COUNTIF(D15:AK15,"P") *0.5

The error is in the AM15 cell formula because if I use just a normal number
in that area it works correctly.

Much appreciated!