FGOMEZ Wrote:
I have a columns with thousand of entries (rows)some are receivables (+)
and
others payables (-), how can I do a formula to add only receivables or
payables in other words negatives only or positives only.
Thanks
I would create two new columns. In the first column, put the formula
=if(a10,a1,"")
In the second column,
=if(a1<0,a1,"")
Then sum each column to get what you need.
--
Teodomiro
------------------------------------------------------------------------
Teodomiro's Profile:
http://www.excelforum.com/member.php...o&userid=33140
View this thread:
http://www.excelforum.com/showthread...hreadid=532429