LinkBack URL
About LinkBacksI 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 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 formulaOriginally Posted by FGOMEZ
=if(a1>0,a1,"")
In the second column,
=if(a1<0,a1,"")
Then sum each column to get what you need.
Still using Excel 2000
use the SUMIF function: sumif(range,"<0") and sumif(range,">0")
"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
>
>
>
>
>
Thanks,
That is exactly what I was looking for.
Fernando
"dlw" <dlw@discussions.microsoft.com> wrote in message
news:D4E01458-2914-4E42-812F-E858F6159C1B@microsoft.com...
> use the SUMIF function: sumif(range,"<0") and sumif(range,">0")
>
> "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
> >
> >
> >
> >
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks