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.
and in English?
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.
Last edited by Bruno_Kitagawa; 02-22-2022 at 07:54 PM.
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.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
I'm sending file attachment
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.
Bom dia Bruno,
Ve se assim te ajuda no que você esta querendo fazer
Fico à disposição.
1 Raio X da Lideran?a GABARITO.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks