| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating total in a column
i would like to get two seperate totals for a column of negative and positive
numbers. is there a way to have it total only the negative numbers together in a column or only the positive numbers together in a column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating total in a column
=SUMIF(A1:A10,"<0") for negative numbers
=SUMIF(A1:A10,"0") for positive numbers -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "tisaman" wrote: i would like to get two seperate totals for a column of negative and positive numbers. is there a way to have it total only the negative numbers together in a column or only the positive numbers together in a column? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating total in a column
i swear, this is truely the most accurate, fastest and accomodating site i
have ever been on. thanks again, for the super fast response. your solution worked, as usual. thanks again "John C" wrote: =SUMIF(A1:A10,"<0") for negative numbers =SUMIF(A1:A10,"0") for positive numbers -- ** John C ** Please remember if your question is answered, to mark it answered :). It helps everyone. "tisaman" wrote: i would like to get two seperate totals for a column of negative and positive numbers. is there a way to have it total only the negative numbers together in a column or only the positive numbers together in a column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Percentage of Total | Excel Worksheet Functions | |||
| Calculating a total with 3 different criterias | Excel Discussion (Misc queries) | |||
| Calculating Total Return | Excel Discussion (Misc queries) | |||
| Total column changes colors when total equals sum of other columns | New Users to Excel | |||
| Is there any way of calculating a running total within a single cell in a column | New Users to Excel | |||
Linear Mode
