ExcelBanter - Easy One

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Easy One (https://www.excelbanter.com/excel-discussion-misc-queries/209211-easy-one.html)

Skydiver

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!

Mike

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!

Mike

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!

All times are GMT +1. The time now is 12:01 PM.