Hello everyone
I am new to Excel and I am wondering if you can help me understand R1C1 formulas
this is the A1 formula:

SUMIF($F$10:$F$31,31,$G$10:$G$31)

This is the R1C1 formula...
SUMIF(R[6]C6:R[27]C6,31,R[6]C7:R[27]C7)
I don't know why it's referencing R[27] when F10 to F31 is 22 rows only.

Cheers
Su