Simple If, Then formula for excel

[Guest]

Hi all,

So I am fairly weak when it comes to Excel formulas, so I'm sure what I
require is really simple, I just have no idea how to formulate it.

Basically, I have a column of values, some of which are negative values and
some are positive, but they are changing from month to month (i.e. accruals
and prepayments). I need to add up all the negative values from the column in
a new cell, and all the positive values in another.

So it will be something like If amount>0 then add to cell, else add to other
cell.

So there you have it, really simple I just have no idea what to do. So if
anyone has time could they have a crack at it.

Thanks,
Mike

 

[Bob Umlas]

=SUMIF(A1:A100,"<0",A1:A100) will total the negative ones
=SUMIF(A1:A100,">0",A1:A100) will total the positive ones.
Adjust range A1:A100 as needed.
Bob Umlas
Excel MVP

 

[Bob Phillips]

=SUMIF(A1:A100,"<0")
=SUMIF(A1:A100,">0")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thanks Bob,

You make it seem to simply, thanks!

=SUMIF(A1:A100,"<0",A1:A100) will total the negative ones
=SUMIF(A1:A100,">0",A1:A100) will total the positive ones.
Adjust range A1:A100 as needed.
Bob Umlas
Excel MVP

 

[Guest]

Hi Bob,

As with the other Bob, thanks for the help, make this stuff seem too easy.

Cheers