How to create a particular SUM formula

[lawrencae]

How do I create a SUM formula that expresses F6 + O6 through O38 minus G6
through G38 equals.

 

[pdberger]

L --

= F6 + SUM(O6:O38) - SUM(G6:G38)

HTH

 

[Pete_UK]

Try this:

=F6 + SUM(O6:O38) - SUM(G6:G38)

Hope this helps.

Pete

 

[lawrencae]

Hello Peter in the UK,

Hi PD Berger,

I am late in replying because I stupidly forgot to ask that I be notified of
replies.
Your reply was exactly like another that I got and neither of them worked.
Since I don't doubt your knowledge of Excel, I am lead to believe I must have
phrased the question incorrectly.
Thank you and I hope you will help me again should the need arise. I will
endeavor to phrase the question more correctly next time.
This time I managed to figure out a formula that worked for me.

Lawrence