Formula excel SOMASE

Navigation
3

I put this formula in Excel and it did not work, why? 

=SOMASE(E2:E158;"<=4>=10";B2:B158)

I can not put it that is greater than 4 and less than 10, it only accepts one of two hypotheses ... how to do?

    
asked by anonymous 27.05.2015 / 19:23

1 answer

5

For multiple criteria, you should use SOMASES 

=SOMASES(B2:B158;E2:E158;">=4";E2:E158;"<=10")

Syntax: 

=SOMASES( intervalo_soma, critérios_intervalo1, critérios1, [critérios_intervalo2, critérios2], ...).
    
27.05.2015 / 19:42
How to use Windows variables in Delphi? How to jump line with View Bag?