Este fórum está sendo desativado

[faeldgr]

Boa tarde

Em uma planilha eu tenho a coluna A com várias datas, e na coluna D vários valores.

Eu gostaria de conseguir, em uma célula qualquer, somar todos os valores correspondentes à data 01/01/20 (por exemplo). Depois na célula de baixo, somar todos os valores correspondentes à data 02/01/2020.
E assim sucessivamente.

[Deciog]

faeldgr , Bom Dia.

Confere se é desta forma que desejas

Se minha resposta foi útil, clique em obrigado é uma forma de agradecimento da ajuda

Decio

[yasanservice3]

Yasan Service Group is one of the most successful well-equipped work teams in the field of drainage, providing services in all parts of تخلیه چاه در تهران Tehran and Karaj, and with modern equipment and skilled workforce always in the field of drainage, chemical, toilet and ... Powerful has moved on and is on the path to progress with customer satisfaction.

Well drainage is تخلیه چاه one of the services that require experienced and specialized tools and labor force and numerous companies in Tehran metropolis are active in this field.

As the drainage and toilet wells are emptied by pumps equipped with powerful suction pumps, the drainage is said to have been designed and manufactured with special machines and machines, which we will discuss in the following.

Opening Pipe لوله بازکنی is a service that is not enough to have only one machine and manpower and the most important advantage of a successful Opening Pipe Company in Tehran is the time and experience along with correct diagnosis because when it comes to the technical Opening Pipe in the building concerned Numerous apparatus and tests identify what tools and how they should be operated.

In fact, in the standard open pipe, a reasonable modeling of how water or wastewater passes during an initial test can determine how to drop a spring or use an air pump that is not obeyed in individual or invalid companies. .

Metropolitan لوله بازکنی در تهران Pipe Facing is facing a fiercely competitive market, which, with the announcement of unreasonable prices as well as poor and unsupported services, only discourages our beloved people from offering our services to the optimum Pipeline Service in Tehran as well as Karaj. , Distrust of labels and tracts and newspapers, and generally traditional advertising

[ThiagoHenrique]

faeldgr , Bom Dia.

Confere se é desta forma que desejas

Se minha resposta foi útil, clique em obrigado é uma forma de agradecimento da ajuda

Decio

Décio não seria mais fácil usar um simples "somase" ??

[Deciog]

Thiago, Boa Tarde.

Usando a função SOMASE ficaria assim

=SOMASE($C$2:$C$28;DATA(2020;1;LIN(B1));$D$2:$D$28)

Mas quero lembrar que o membro não informou qual a versão do seu Excel

A função SOMASE é para versão de 2013 até 2019

Por isso coloquei a função SOMARPRODUTO serve para todas

Também pode usar a função SOMA desta forma

=SOMA(SE(DATA(2020;1;LIN(B1))=$C$2:$C$28;$D$2:$D$28)) encerrar com CTRL+SHIFT+ENTER

Espero ter explicado

Abraços

Decio