How to create a particular SUM formula
 

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

How to create a particular SUM formula
 

L --

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

HTH

"lawrencae" wrote:

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

How to create a particular SUM formula
 

Try this:

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

Hope this helps.

Pete

On Apr 11, 6:36*pm, lawrencae
wrote:
How do I create a SUM formula that expresses F6 + O6 through O38 minus G6
through G38 equals.

How to create a particular SUM formula
 

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


"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Apr 11, 6:36 pm, lawrencae
wrote:
How do I create a SUM formula that expresses F6 + O6 through O38 minus G6
through G38 equals.