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?

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?

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?