Hello all -

I have a particularly tricky function that I'm troubleshooting by
splitting the parts into different cells. I have the various cells
adding up correctly, but still i have a typo or some problem in the
original cell formula.

Is there a way I can merge the formulas in cells? For instance, if I
have

Column U
=COUNTIF(Q$10:$Q10,$Q10 )-1

Column W
=RANK($Q10,$Q$10:$Q$29)

Column X
=U10+W10

I would like for column X to become:

COUNTIF(Q$10:$Q10,$Q10 )-1 + RANK($Q10,$Q$10:$Q$29)