1
I have problems applying the formula SOMAR.SE.S. 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 criterion I use are values (in this case I confirmed and these return the right 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 (so I save a lot of time dragging the formulas) with the values in them, but the sum of the 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 value (but few).
I wonder if you could help me with this problem, I’ve been around this for two days...
If I haven’t been explicit about 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 criterion) and P (Using the cells as criterion)
I made the same formula here and passed ok,
=SOMASE(E1:E9;">="&C3;E1:E9)what content of columns E, and C you can’t see in the image ?– Rovann Linhalis
https://ibb.co/c2yJ8Q . This link contains the data in columns E and C, had to delete the values in columns C when they were <= 0, so there are empty cells (It will be due to this?).
– Pascual Felicio
I tested with blank cells and passed normally.
– Rovann Linhalis
Buddy, I’m finding it odd that your formula is
SOMA.SEand notSOMASE, Other than that, everything ok, has to work properly. Try to create a new file from scratch, copy the tables and test again. The problem may be that some fields are like text or something... because its formula, apart from the "point" (SOMA.SE), it’s all right.– Evert
From what I saw depends on the version, I do not know if having the Portuguese version (PT-PT) implies changing the formulas. That of some fields that may be as text, how do I turn it around. Meanwhile I will try to create the file from scratch. Thank you
– Pascual Felicio