If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtract several rows from a total
Hi Guys,
I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda |
#2
|
|||
|
|||
Linda
=C32-SUM(C34:C40) Regards Trevor "LMB" wrote in message ... Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda |
#3
|
|||
|
|||
Look at the SUM Worksheet Formula
C41: =C32 - SUM(C34:Offset(C41,-1,0)) I guess C33 is on a blank row or at least that cell is empty. The use of OFFSET(C41,-1,0) instead of C40 allows you to insert a row before row 41 later that would also be subtracted. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "LMB" wrote in message ... Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda |
#4
|
|||
|
|||
LMB wrote:
Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda Here's one way..put this in C41 = C32-(SUM( C34:C40)) |
#5
|
|||
|
|||
Thanks you guys!
"LMB" wrote in message ... Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda |
#6
|
|||
|
|||
If you gave cell C32 the RangeName "Price", and gave the range C34:C40 the RangeName "Costs", then you could use
=price-SUM(costs) Vaya con Dios, Chuck, CABGx3 "LMB" wrote in message ... Hi Guys, I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an answer but I want several rows to be subtracted. What would my formula be? I have used the insert function feature before but I don't see diff or anything that looks like a subtraction function in there. Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
help needed | jkendrick75 | Running & Setting Up Queries | 19 | March 17th, 2005 02:37 PM |
Grand Total Problem | PW11111 | Running & Setting Up Queries | 2 | March 11th, 2005 05:44 PM |
how do I subtract several cells from one total | highway | General Discussion | 2 | November 5th, 2004 04:30 PM |
Repeat Records - Please Help? | Repeat records | Running & Setting Up Queries | 9 | September 29th, 2004 05:29 PM |
Inserting multiple rows into a table while maintaining data? | JAnderson | General Discussion | 2 | July 8th, 2004 05:45 PM |