rsacramento Posted September 23, 2009 at 03:41 PM Report Share #288321 Posted September 23, 2009 at 03:41 PM eu tenho esta fórmula: =SOMA(SE(movimentos!$N$15:$N$1000="jan";SE(movimentos!$O$15:$O$1000="fechado";movimentos!$K$15:$K$1000;0);0)) basicamente, e dispensando os ifs, soma a coluna "O" por meses ora bem, o que eu quero é editar esta fórmula somando também por meses mas adicionando o valor da coluna "O" ao da coluna "Q" como faço isso? obrigadoantecipadamente Link to comment Share on other sites More sharing options...
rsacramento Posted September 23, 2009 at 04:18 PM Author Report Share #288328 Posted September 23, 2009 at 04:18 PM assim: =SOMA(SE(movimentos!$N$15:$N$1000="jun";SE(movimentos!$O$15:$O$1000="fechado";movimentos!$K$15:$K$1000+movimentos!$Q$15:$Q$1000;0);0)) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now