How to add only the highest values of a numerical sequence in Excel?

Asked

Viewed 218 times

2

I want to add only the values greater than '600' of this numerical sequence, I tried to use =SOMASE(B51:B60;>600;B51:B60), but it didn’t work! right after inserting the (>)major symbol, it overrides the rest of the formula, as I do to add only values greater than '600' ??inserir a descrição da imagem aqui

excel

2 answers

3


Your logic is almost right, only had a small error when implementing, see the example:

=SOMASE(rage; ">1000")

Example:

=SOMASE(B51:B60; ">1000")

Where range is where you want to add, and the ">10" is the exclusion parameter.

Reference: https://exceljet.net/formula/sum-if-greater-than

2

Another way to do the formula, in addition to what @Bulfaitelo mentioned, is to add a "&" between the comparison signal and the value area.

Example:

=SOMASE(B51:B60; ">" & 600)

With this you can reference the value of the criterion for a range.

Example of a sum of values greater than the average of the same range:

=SOMASE( B51:B60; ">" & MÉDIA( B51:B60 ) )

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.