Formatting a SUM arguement
 

How to subtract a range, j4 through p4, from i4.

Formatting a SUM arguement
 

One way:

= -SUM(-I4, J4:P4)

In article ,
lawrencae wrote:

How to subtract a range, j4 through p4, from i4.

Formatting a SUM arguement
 

"JE McGimpsey" wrote:

One way:

= -SUM(-I4, J4:P4)

In article ,
lawrencae wrote:

How to subtract a range, j4 through p4, from i4.

I appreciate your good help.

Your way, which looked ridiculous and illogical, worked just fine, so it
must have been wise and logical. It took me several tries before it worked. I
don't know what I did wrong.

Formatting a SUM arguement
 

Mon, 31 Dec 2007 23:49:05 -0800 from lawrencae
:
How to subtract a range, j4 through p4, from i4.

=I4-SUM(J4:P4)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Formatting a SUM arguement
 

Thanks a lot, Stan Brown. I think you did it for me. Another guy offer a
solution,
= -SUM(-I4, J4:P4), that seemed to work, but your appears cleaner and better
for my use.
I saw your website. I will checkout it out close once I get through this
horrendous project of setting up a Small Business Daily Report (income,
expenses, and hoped for profit).
I am a newbie with Excel.
Thanks again.

Lawrence S. Miller


"Stan Brown" wrote:

Mon, 31 Dec 2007 23:49:05 -0800 from lawrencae
:
How to subtract a range, j4 through p4, from i4.

=I4-SUM(J4:P4)

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Formatting a SUM arguement
 

Sat, 5 Jan 2008 04:48:00 -0800 from lawrencae
:
"Stan Brown" wrote:
Mon, 31 Dec 2007 23:49:05 -0800 from lawrencae
:
How to subtract a range, j4 through p4, from i4.
=I4-SUM(J4:P4)

Thanks a lot, Stan Brown. I think you did it for me.

Happy to help! Thanks for the feedback.

Another guy offer a solution, = -SUM(-I4, J4:P4), that seemed to
work, but your appears cleaner and better for my use.

I saw that after I had posted my solution. The two are algebraically
identically, but I always try to write formulas that are as close as
possible to how the requirement was expressed in English.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/