How to adjust formula

S

SS

I need to adjust this formula...

=SUM(P9:p33)

The figure I have in cell P9 i want divide by cell O3, and then I want to
add P9:p33 after this calculation has been done.

thanks
 
J

JoeU2004

SS said:
I need to adjust this formula...
=SUM(P9:p33)

The figure I have in cell P9 i want divide by cell O3,
and then I want to add P9:p33 after this calculation
has been done.
Click to expand...

Does this do it for you?

=P9/O3 + SUM(P9:p33)
 
S

SS

JoeU2004 said:
Does this do it for you?

=P9/O3 + SUM(P9:p33)
Click to expand...

Ok thanks for that.

I was trying...
=SUM(P09/O3)+(P9:p33)

I can now see where I was going wrong,

Thank you
 
Top