marcleo
27-03-2013 03:17:09
Alguem pode me ajudar na soma de dados.
Para emcontrar o resultado coloquei uma formula muito grande, Veja.
=SOMASES($Q$2:$Q$500;$K$2:$K$500;$DA$5;$O$2:$O$500;CY7)+SOMASES($V$2:$V$500;$K$2:$K$500;$DA$5;$T$2:$T$500;CY7)+SOMASES($AA$2:$AA$500;$K$2:$K$500;$DA$5;$Y$2:$Y$500;CY7)+SOMASES($AF$2:$AF$500;$K$2:$K$500;$DA$5;$AD$2:$AD$500;CY7)+SOMASES($AK$2:$AK$500;$K$2:$K$500;$DA$5;$AI$2:$AI$500;CY7)+SOMASES($AP$2:$AP$500;$K$2:$K$500;$DA$5;$AN$2:$AN$500;CY7)+SOMASES($AU$2:$AU$500;$K$2:$K$500;$DA$5;$AS$2:$AS$500;CY7)+SOMASES($AZ$2:$AZ$500;$K$2:$K$500;$DA$5;$AX$2:$AX$500;CY7)+SOMASES($BE$2:$BE$500;$K$2:$K$500;$DA$5;$BC$2:$BC$500;CY7)+SOMASES($BJ$2:$BJ$500;$K$2:$K$500;$DA$5;$BH$2:$BH$500;CY7)
Alquem sabe como dimimuir isso !!!
Segue exemplo da planilha.
Para emcontrar o resultado coloquei uma formula muito grande, Veja.
=SOMASES($Q$2:$Q$500;$K$2:$K$500;$DA$5;$O$2:$O$500;CY7)+SOMASES($V$2:$V$500;$K$2:$K$500;$DA$5;$T$2:$T$500;CY7)+SOMASES($AA$2:$AA$500;$K$2:$K$500;$DA$5;$Y$2:$Y$500;CY7)+SOMASES($AF$2:$AF$500;$K$2:$K$500;$DA$5;$AD$2:$AD$500;CY7)+SOMASES($AK$2:$AK$500;$K$2:$K$500;$DA$5;$AI$2:$AI$500;CY7)+SOMASES($AP$2:$AP$500;$K$2:$K$500;$DA$5;$AN$2:$AN$500;CY7)+SOMASES($AU$2:$AU$500;$K$2:$K$500;$DA$5;$AS$2:$AS$500;CY7)+SOMASES($AZ$2:$AZ$500;$K$2:$K$500;$DA$5;$AX$2:$AX$500;CY7)+SOMASES($BE$2:$BE$500;$K$2:$K$500;$DA$5;$BC$2:$BC$500;CY7)+SOMASES($BJ$2:$BJ$500;$K$2:$K$500;$DA$5;$BH$2:$BH$500;CY7)
Alquem sabe como dimimuir isso !!!
Segue exemplo da planilha.