Formatting a SUM arguement

  • Thread starter Thread starter lawrencae
  • Start date Start date
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.
 
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
(e-mail address removed)
 
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.
 
You must log in or register to reply here.

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

Similar Threads

Filtering with SUMIFS 1
IF OR statement help 5
=IF((I4="R");H4;IF((H4>0);H4*E4;IF((I4=0);J4*E4;IF((J4>H4);J4*E4) 2
Excel IF Function problem in Excel.... 2
Returning last number(time) in a row of cells 4
running total between two dates 3
How do I ignore blank cells while averaging the solutions of equat 2
drop down list dependent on another drop down list. 14

Back
Top