calculating total in a column

T

tisaman

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?
 
J

John C

=SUMIF(A1:A10,"<0") for negative numbers
=SUMIF(A1:A10,">0") for positive numbers
 
T

tisaman

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cumulative formula for word table 0
SUMIF with broken range 10
Program buttons to create a word document 0
Setting column width in a table with a macro is not working 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
Change the colour of a neighbouring cell 6
Excel does not accept text format! 0
Counting consecutive negative value 7

Top