I'm having trouble applying the SOMAR.SE.S formula. In the image the sums in column N use the following formula (N4):
=SOMA.SE($E$2:$E$4465;">=5,48";$C$2:$C$4465)-SOMA.SE($E$2:$E$4465;">5,52";$C$2:$C$4465)
These formulas the criteria I use are values (in this case, I have confirmed them and they return the correct sum).
But for the case of column Q, the formula used is as follows (Q4):
=SOMA.SE($E$2:$E$4465;">="&K4;$C$2:$C$4465)-SOMA.SE($E$2:$E$4465;">"&L4;$C$2:$C$4465)
For this formula, instead of using the values, I wanted to apply the cells (thus saving a lot of time by dragging the formulas) with the values in them, but the sum of SOMA.SE is not returning the 6387.2 returns 5896.8.
And you can see from the image that many of the sums are giving a wrong value, while some are giving the right (but few) value.
Can you help me with this problem, I've been around this for 2 days ...
If I was not explicit in something let me know.
PS: With the formula CONTAR.SE.S happens to me exactly the same error, columns M (directly using the values as criteria) and P (Using the cells as a criterion)
