| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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 |
|
#8
|
|||
|
|||
|
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 Hmmm. Six answers in sixteen minutes -- AND they are all the SAME!! --ron |
|
#9
|
|||
|
|||
|
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 |
|
#10
|
|||
|
|||
|
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 |
|
#11
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
