searching for a number different from zero

[Andrew Diebold]

I have two numbers in a single column. One number will
equal zero, while the other will be different from zero.
I want to pull the one number that is different from zero
into a single cell in another workbook. The numbers will
change from day to day. It will always look something
like this.

Purchases: $0

Redemptions: ($25)

or

Purchases: $25

Redemptions: $0

Any ideas?

Thanks in advance.

 

[Aladin Akyurek]

If that regular, that is, either a 0 or a non-zero number, use...

=SUM(Cell1,Cell2)

or

=Cell1+Cell2