Cell divided by range

[simontompkins]

Hi
I would like do a calculation that is:

A2
4
B2
6
C2
8

I want a formula that does:
=C2/(A2:C2) or =SUMC/2(A2:C2) Neither of which work

I’ve tried different ways of altering the syntax but I can’t get it to work. The closest I get is
=SUM(A2:C2)/C2
But I want it the other way round.
Obviously I could total the cells and then work with that cell but I’m trying to cut down on cells used so hoping to be able to find a calculation that only needs one cell for the calculation.

Many thanks for any suggestions anyone has
Kind regards
Simon

[LeroyG]

@simontompkins

=SUM(A2:C2)/C2

For 8/18: =C2/SUM(A2:C2)

=A2 will give the same result that =SUM(A2) or =SUM(A2:A2)
=A2+B2 will give the same result that =SUM(A2;B2) or =SUM(A2:B2) (first example with semicolon, second with colon)*
=A2+B2+C2 will give the same result that =SUM(A2;B2;C2) or =SUM(A2:C2)
*The semicolon will mean something like and, and the colon, something like to or till.

[simontompkins]

Thanks ever so much LeroyG much appreciated