3
I put this formula in Excel and it didn’t work because?
=SOMASE(E2:E158;"<=4>=10";B2:B158)
I can’t put it above 4 and below 10, he only accepts one of two hypotheses... how to do?
1 answer
5
For various criteria, you must use the SOMASES
=SOMASES(B2:B158;E2:E158;">=4";E2:E158;"<=10")
Syntax:
=SOMASES( intervalo_soma, critérios_intervalo1, critérios1, [critérios_intervalo2, critérios2], ...).
Browser other questions tagged excel
You are not signed in. Login or sign up in order to post.