Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell formula.
I wish to add together cells C12:C13, and to then add cells D14:D17. and to
then subtract The answer from Column C from Column D and to shoe the result in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would work. Help Help Help;. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell formula.
try this: =sum(c12:c13) - sum(d14:d17)
"azarat" wrote in message ... I wish to add together cells C12:C13, and to then add cells D14:D17. and to then subtract The answer from Column C from Column D and to shoe the result in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would work. Help Help Help;. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell formula.
"Tieske" wrote: try this: =sum(c12:c13) - sum(d14:d17) "azarat" wrote in message ... I wish to add together cells C12:C13, and to then add cells D14:D17. and to then subtract The answer from Column C from Column D and to shoe the result in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would work. Help Help Help;. What a star. Your formula works. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell formula.
Try this:
=C12+C13-SUM(D14:D17) or this: =SUM(D14:D17)-C12-C13 (it's not clear what you want to subtract from what). Hope this helps. Pete On Jun 27, 12:29*pm, azarat wrote: I wish to add together cells C12:C13, and to then add cells D14:D17. and to then subtract The answer from Column C from Column D and to shoe the result in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would work. Help Help Help;. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excell formula.
IF? you want to sum c12:c13 and then subtract the sum of d14:d17
=sum(C12:C13)-sum(D14:D17) -- Don Guillett Microsoft MVP Excel SalesAid Software "azarat" wrote in message ... I wish to add together cells C12:C13, and to then add cells D14:D17. and to then subtract The answer from Column C from Column D and to shoe the result in a new cell. I have tried =sum(C12:C13)-D14:D17) thinking that BODMAS would work. Help Help Help;. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell formula help | Excel Worksheet Functions | |||
excell formula can any one help | Excel Discussion (Misc queries) | |||
Excell convert formula row to formula column | Excel Worksheet Functions | |||
Formula in Excell | Excel Worksheet Functions | |||
excell formula 9+5=4 not 14 | Excel Worksheet Functions |