Formatting a SUM arguement

L

lawrencae

JE McGimpsey said:
One way:

= -SUM(-I4, J4:p4)
Click to expand...
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.
 
L

lawrencae

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
[email protected]
 
S

Stan Brown

Sat, 5 Jan 2008 04:48:00 -0800 from lawrencae
Thanks a lot, Stan Brown. I think you did it for me.
Click to expand...

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.
Click to expand...

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.
 
Top