Is there a better way?

[Ltat42a]

I have a cell that calculates income. I have a range of cells tha
contain expenses.
As I enter the expenses, excel subtracts the expenses from th
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.

Than

 

[Peo Sjoblom]

=D14-SUM(D1730)

 

[Ron Rosenfeld]

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(D1730)


--ron

 

[Paul B]

Ltat42a, here is one way, =D14-SUM(D1730)
--
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

 

[Bob Phillips]

=D14-SUM(D1730)

--

HTH

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

 

[Guest]

=D14-SUM(D1730)

 

[Ron Coderre]

Try this:

D32: =D14-SUM(D1730)

Does that help?

Regards,
Ron

 

[Ron Rosenfeld]

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

 

[Guest]

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

 

[Bob Phillips]

It must be a yes then )

Bob

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


--ron

 

[Ltat42a]

Try this:

D32: =D14-SUM(D1730)

Does that help?

Regards,
Ron

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

JF