Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how can I subtract the contents of several cells
I know that by entering SUM=(b1:d1) in the formula bar, this will add the
contents of these cells. How can I do this with subtraction without entering =(b1-c1-d1)? Thanks! |
#2
|
|||
|
|||
One way:
=B1-SUM(C1:D1) Alternatively, you could array-enter (CTRL-SHIFT-ENTER or CMD-RETURN): =SUM(B1,-C1:D1) Note that the second solution won't ignore text. In article , "whiteteeth" wrote: I know that by entering SUM=(b1:d1) in the formula bar, this will add the contents of these cells. How can I do this with subtraction without entering =(b1-c1-d1)? Thanks! |
#3
|
|||
|
|||
JE McGimpsey wrote...
.... Alternatively, you could array-enter (CTRL-SHIFT-ENTER or CMD-RETURN): =SUM(B1,-C1:D1) Note that the second solution won't ignore text. .... =-SUM(-B1,C1:D1) will avoid the need for array entry and will only fail to ignore text in B1. This is an old (REAL OLD) 123 trick. |
#4
|
|||
|
|||
So old that it should have been second nature to me...
In article . com, "Harlan Grove" wrote: =-SUM(-B1,C1:D1) will avoid the need for array entry and will only fail to ignore text in B1. This is an old (REAL OLD) 123 trick. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rotate a box with a cell's contents | Excel Discussion (Misc queries) | |||
Adding contents of cells by clicking in Excel 2002 | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Delete contents of unprotected cells in workbook | Excel Worksheet Functions |