# Soma de dados de abas diferentes na mesma planilha.

1. ## Soma de dados de abas diferentes na mesma planilha.

o arquivo tem 2 abas:
- Exercício
- Gabarito

No gabarito temos quanto vale cada célula referente a tabela do Exercício, que será apenas assinalado com "X" e puxará os valores da tabela Gabarito e isso fará com sejam feitas as somas no final de cada tópico para que as ações sejam tomadas com base nos resultados obtidos.

2. ## Re: Soma de dados de abas diferentes na mesma planilha.

and in English?

3. ## Re: Add data in different template on the same file

the file has 2 tabs:
- Exercise
- feedback

In the template, we have how much each cell referring to the Exercise table is worth, which will only be marked with "X" and will pull the values from the Template table and this will make the sums at the end of each topic so that the actions are taken based on the results obtained.

4. ## Re: Soma de dados de abas diferentes na mesma planilha.

Hello Bruno_Kitagawa and Welcome to Excel Forum.
We may be in a better position to help if we could see a sample of the file.
Instructions for attaching an Excel file to your next post are given in the banner at the top of the page.
Let us know if you have any questions.

5. ## Re: Soma de dados de abas diferentes na mesma planilha.

I'm sending file attachment

6. ## Re: Soma de dados de abas diferentes na mesma planilha.

Cell D3 on the Exercício sheet is populated using: =Exercício!D3 which is producing a circular reference.
Can we assume that Cell D3 on the Exercício sheet should be populated with an "X"?
If so should cell D9 display 1?
If the answer to both of the above is yes, then paste the following into cell C9 and drag the fill handle to the right: =(COLUMNS(\$C9:C9)-1)*COUNTIFS(C3:C8,"x")
If the answer to either of the above is no, then please give us a few manual examples as to what you would like formulas/code to automate.
Let us know if you have any questions.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1