Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple If, Then formula for excel
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 amount0 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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple If, Then formula for excel
=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 "mike_vr" wrote in message ... 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 amount0 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple If, Then formula for excel
=SUMIF(A1:A100,"<0")
=SUMIF(A1:A100,"0") -- HTH RP (remove nothere from the email address if mailing direct) "Bob Umlas" wrote in message ... =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 "mike_vr" wrote in message ... 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 amount0 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple If, Then formula for excel
Thanks Bob,
You make it seem to simply, thanks! "Bob Umlas" wrote: =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 "mike_vr" wrote in message ... 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 amount0 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple If, Then formula for excel
Hi Bob,
As with the other Bob, thanks for the help, make this stuff seem too easy. Cheers "Bob Phillips" wrote: =SUMIF(A1:A100,"<0") =SUMIF(A1:A100,"0") -- HTH RP (remove nothere from the email address if mailing direct) "Bob Umlas" wrote in message ... =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 "mike_vr" wrote in message ... 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 amount0 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming a simple formula | New Users to Excel | |||
simple interest formula in excel | Excel Discussion (Misc queries) | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions |