+ Reply to Thread
Results 1 to 6 of 6

Soma de dados de abas diferentes na mesma planilha.

  1. #1
    Registered User
    Join Date
    10-05-2020
    Location
    Brazil
    MS-Off Ver
    Office 2016
    Posts
    3

    Post 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. #2
    Forum Expert
    Join Date
    09-07-2014
    Location
    Israel
    MS-Off Ver
    office 365
    Posts
    2,603

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

    and in English?

  3. #3
    Registered User
    Join Date
    10-05-2020
    Location
    Brazil
    MS-Off Ver
    Office 2016
    Posts
    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.
    Last edited by Bruno_Kitagawa; 02-22-2022 at 07:54 PM.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,079

    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.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Registered User
    Join Date
    10-05-2020
    Location
    Brazil
    MS-Off Ver
    Office 2016
    Posts
    3

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

    I'm sending file attachment
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,079

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Vincular uma referencia de planilha em uma célula
    By eliel.hef in forum Excel General
    Replies: 0
    Last Post: 06-30-2021, 09:28 AM
  2. entrada de dados
    By andersonps in forum Non English Excel
    Replies: 1
    Last Post: 08-26-2015, 10:31 AM
  3. Colunas Agrupadas em abas diferente
    By ljrbrasil in forum Non English Excel
    Replies: 5
    Last Post: 05-18-2012, 10:24 AM
  4. Planilha de Impostos Federais e Estaduais
    By Jemelly Rustom in forum Excel General
    Replies: 0
    Last Post: 01-28-2006, 10:10 AM
  5. Eliminando Iconos que Realizan Dos Tareas Diferentes
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-28-2005, 09:48 AM
  6. [SOLVED] planilha excel
    By Othon Moraes in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 05:06 PM
  7. SOMAR CELULAS DE PLANILHAS DIFERENTES
    By GABRIEL in forum Excel General
    Replies: 0
    Last Post: 01-07-2005, 04:06 PM

Bookmarks

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