I got this working in another spreadsheet, but in my main spreadsheet, the rank is returning #N/A. T

Screenshot 2025-03-21 103628.png

My values are all numbers. No errors in any of the columns in question. Here's the formula:
=SUMPRODUCT(($A$2:$A$19=A2)*($B$2:$B$19>B2))+1


Can anyone think of why this wouldn't work in my larger spreadsheet? And sorry, I can't share the original spreadsheet.