=@count(RANGE,{expr}) take half a cell's value in {expr}

[Nora-n]

Hi,

I'm trying to do a basic counting cell. I want to know how many of a column's values are above another value, but set in another cell.

For context, I have a spreadsheet of my student's marks, but not all exams are on the same total of points. I added a row "Max points" in the 45th row of each column, and I want to know, for each column, how many values are above half of the max points.

I tried @count(E1:E44,E0>=E45/2) and I do get a result, but not the one I get from @count(E1:E44,E0>=10/2) for an exam ranked over 10 max points.

I searched how the {expr} works in the help and in discussions and issue on this Github, but didn't find an answer. I could make another row named "Half points" and use that, but I'm sure there's an easy answer :-).

Thanks!

[Nora-n]

Solution: use @nval("E", 45") instead of E45: @count(E$1:E$44,E0>=@nval("E", 45)/2).