="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!