ExcelBanter - How do I get to add up only the values than 0?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I get to add up only the values than 0? (https://www.excelbanter.com/excel-worksheet-functions/264662-how-do-i-get-add-up-only-values-than-0-a.html)

Anri

How do I get to add up only the values than 0?

How do I get to add up only the values than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0

Jacob Skaria

How do I get to add up only the values than 0?

Use SUMIF()

=SUMIF(Q8,"0")

or

=SUMIF(A1:A10,"0")

--
Jacob (MVP - Excel)

"Anri" wrote:

How do I get to add up only the values than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0

Jacob Skaria

How do I get to add up only the values than 0?

OR use MAX() as below

=MAX(0,Q8)

=(MAX(0,Q8)*0.5)+MAX(0,Q8)

--
Jacob (MVP - Excel)

"Jacob Skaria" wrote:

Use SUMIF()

=SUMIF(Q8,"0")

or

=SUMIF(A1:A10,"0")

--
Jacob (MVP - Excel)

"Anri" wrote:

How do I get to add up only the values than 0?

Only count: =((Q8)*0.5)+(Q8) .... if larger than 0

All times are GMT +1. The time now is 09:57 PM.