| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy One
I have a dollar amount in B1 ($97,903.85), a dollar amount in B2
($95,504.38)...with ups and downs through B25. In a separate column, I would like to show the amount gained/lossed. Help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy One
"Skydiver" wrote: I have a dollar amount in B1 ($97,903.85), a dollar amount in B2 ($95,504.38)...with ups and downs through B25. In a separate column, I would like to show the amount gained/lossed. Help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Easy One
="Gained $" & SUMIF(B2:B25,"0") & " Loss $" & SUMIF(B2:B25,"<0")
"Skydiver" wrote: I have a dollar amount in B1 ($97,903.85), a dollar amount in B2 ($95,504.38)...with ups and downs through B25. In a separate column, I would like to show the amount gained/lossed. Help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pls help, is there an easy way to | Excel Worksheet Functions | |||
| How to sum in an easy way? | Excel Discussion (Misc queries) | |||
| This should be easy | Excel Worksheet Functions | |||
| probably easy but.... | Excel Worksheet Functions | |||
| new user with easy question? not easy for me | New Users to Excel | |||
Linear Mode
