Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I subtract 1:0:26 from 1:34:54 and get 12:34:38 AM - I want total. | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Deleting rows containing common data | Excel Discussion (Misc queries) | |||
Adding Rows to Master Sheet | New Users to Excel | |||
How do I write a formula to subtract a # from a total ONLY if the. | Excel Worksheet Functions |