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.

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)

Ok thanks for that.

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

I can now see where I was going wrong,

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top