Justifiably breathless: https://buttondown.email/hillelwayne/archive/excel-is-pretty-dang-cool

C1#^2

that's one I didn't know. And the grand finale:

LET(x, SUM(OFFSET(cell#,-1,-1,3,3)), (x=3)+cell#*(x=4))