Easy One

[Skydiver]

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]

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]

="Gained $" & SUMIF(B2:B25,">0") & " Loss $" & SUMIF(B2:B25,"<0")