Summing a range based on value criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. I am trying to find a way to only sum the numbers in a range of data
that are positive in one cell, and negative values in another cell. Can
anyone please tell me what formula to use to analyze the values in the range
of data to pick out only the cells with either a <0 or >0 value and to sum
only those values?

Thank you very much. This one is making my head feel like it's going to
explode.

Mike
 
=sumif(a1:a10,">"&0)
=sumif(a1:a10,"<"&0)


Hello. I am trying to find a way to only sum the numbers in a range of data
that are positive in one cell, and negative values in another cell. Can
anyone please tell me what formula to use to analyze the values in the range
of data to pick out only the cells with either a <0 or >0 value and to sum
only those values?

Thank you very much. This one is making my head feel like it's going to
explode.

Mike
Click to expand...
 

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

Excel formula, sum the value cell and if empty cell left blank 0
complex count formulas using multiple criteria in different ranges 4
Conditional Sum - variable criteria 5
Excel Need Countifs Formula Help 0
Summing based on a range of criteria 3
COUNTIF absolute value of cells in a range are > 0 8
Summing rows using formulas with variables 1
sum last 3 numbers greater that 0 in a range 0

Back
Top