Dividing by another equation

[Dan Morris]

Hi there - I'm sure this is fairly easy but I can't make it work and keep getting error messages, so would be most grateful for some guidance please.

This is what I'm trying:

=SUM(Y8/(R8:W8))

So the result would equal the number in cell Y8 being divided by the number created by adding together the numbers in fields R8 to W8

It just raises an error message.

Can anyone help?

Thank you so much. Dan

 

[gaz_chops]

Try

=y8/sum(R8:W8)

 

[Dan Morris]

Try

=y8/sum(R8:W8)

FANTASTIC! Thank you so much; that works. Best wishes, Dan

 

[gaz_chops]

You're welcome.