| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtracting
Hello,
I was wondering how do you have column of numbers and subtract them. For example the values I have in column "F" are my "Totals": $225.00, $32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00. The range of cells is "F4:F12. I want to place the formula in cell "F13". So, How do take cell "F4" ($225.00) and subtract cells "F5:F12" ($32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00) So that i can get the balance remaining after those expenses? Thanks Josh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtracting
=F4-SUM(F5:F12)
"Josh Davis" wrote: Hello, I was wondering how do you have column of numbers and subtract them. For example the values I have in column "F" are my "Totals": $225.00, $32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00. The range of cells is "F4:F12. I want to place the formula in cell "F13". So, How do take cell "F4" ($225.00) and subtract cells "F5:F12" ($32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00) So that i can get the balance remaining after those expenses? Thanks Josh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtracting
=f4-sum(f5:f12)
"Josh Davis" wrote in message ... Hello, I was wondering how do you have column of numbers and subtract them. For example the values I have in column "F" are my "Totals": $225.00, $32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00. The range of cells is "F4:F12. I want to place the formula in cell "F13". So, How do take cell "F4" ($225.00) and subtract cells "F5:F12" ($32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00) So that i can get the balance remaining after those expenses? Thanks Josh |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtracting
The other 2 solutions will work as well but an alternate is to enter the
value in cell F4 as a negative then Sum(f4-f12) "Larry S" wrote: =f4-sum(f5:f12) "Josh Davis" wrote in message ... Hello, I was wondering how do you have column of numbers and subtract them. For example the values I have in column "F" are my "Totals": $225.00, $32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00. The range of cells is "F4:F12. I want to place the formula in cell "F13". So, How do take cell "F4" ($225.00) and subtract cells "F5:F12" ($32.09, $16.27, $16.27, $19.48, $15.35, $44.69. $20.00, & $0.00) So that i can get the balance remaining after those expenses? Thanks Josh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
| How to display 5.5 hours instead of 5.30 when adding \ subtracting | Excel Discussion (Misc queries) | |||
| subtracting columns one at a time? | Excel Discussion (Misc queries) | |||
| Subtracting weekdays from a date: | Excel Worksheet Functions | |||
| Adding Subtracting Time Formula-Horse Racing | Excel Discussion (Misc queries) | |||
Linear Mode
