ExcelBanter - Is there a better way?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Is there a better way? (https://www.excelbanter.com/excel-discussion-misc-queries/55332-there-better-way.html)

Ltat42a

Is there a better way?

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Peo Sjoblom

Is there a better way?

=D14-SUM(D17:D30)

--

Regards,

Peo Sjoblom

"Ltat42a" wrote in
message ...

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Ron Rosenfeld

Is there a better way?

On Mon, 14 Nov 2005 10:28:55 -0600, Ltat42a
wrote:

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

=D14-SUM(D17:D30)

--ron

Paul B

Is there a better way?

Ltat42a, here is one way, =D14-SUM(D17:D30)
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Ltat42a" wrote in
message ...

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Bob Phillips

Is there a better way?

=D14-SUM(D17:D30)

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Ltat42a" wrote in
message ...

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Sloth

Is there a better way?

=D14-SUM(D17:D30)

"Ltat42a" wrote:

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Ron Coderre

Is there a better way?

Try this:

D32: =D14-SUM(D17:D30)

Does that help?

Regards,
Ron

--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=484894

Ron Rosenfeld

Is there a better way?

Ron Coderre

Is there a better way?

Also amusing.....
On this forum, my reply was listed 6th.
On the ExcelTip forum, where I entered my post, I'm listed 1st and at my
posting time nobody else's reply even appeared there.

So depending on where the OP looks for the replies . . .

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron

"Ron Rosenfeld" wrote:

On Mon, 14 Nov 2005 10:28:55 -0600, Ltat42a
wrote:

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

Hmmm. Six answers in sixteen minutes -- AND they are all the SAME!!

--ron

Bob Phillips

Is there a better way?

It must be a yes then :-))

Bob

"Ron Rosenfeld" wrote in message
...
On Mon, 14 Nov 2005 10:28:55 -0600, Ltat42a
wrote:

I have a cell that calculates income. I have a range of cells that
contain expenses.
As I enter the expenses, excel subtracts the expenses from the
sub-total gross.

D32 contains this formula -
=SUM(D14-D17-D18-D19-D20-D21-D22-D23-D24-D25-D26-D27-D28-D29-D30)

Is there a better way to create this formula?
D14 is my gross income, D17-D30 are my expenses.

Thanx

Hmmm. Six answers in sixteen minutes -- AND they are all the SAME!!

--ron

Ltat42a

Is there a better way?

Ron Coderre Wrote:
Try this:

D32: =D14-SUM(D17:D30)

Does that help?

Regards,
Ron

Yes - much better! Thanx Ron - and everyone else!

JF

--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile: http://www.excelforum.com/member.php...o&userid=24735
View this thread: http://www.excelforum.com/showthread...hreadid=484894

All times are GMT +1. The time now is 02:42 AM.