• 0

Need help with a (hopefully) basic Excel formula


Question

I have a column of numbers which include negative figures.

 

I wish to separate the positive and negative figures, then add them all together.

 

For example: The column has this:

 

10

20

-30

40

-20

 

I want all the negative numbers adding up, and all the positive numbers adding up, resulting in (for the above example): -50 and 70.

 

There must be an easy way to do this, but I'm not an Excel whizz! :)

 

The actual speadsheet that I need to do this on is here in my Dropbox: https://www.dropbox.com/s/gcej7hudhxh5bja/figures.csv?dl=0

 

Thanks!

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

You can apply a filter to the column of values to show only values greater than zero, copy those to a new column, and do the same for values less than zero; then sum them using =sum(cells).

 

You can also just use =if(A1>0,A1), and =if(A1<0,A1) to output values of positive and negative numbers from your data column into new columns, then sum the output.

 

Probably more clever ways to do it, but I'm also not an Excel whiz.

figures.zip

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.