This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Is there simple formula to add values from different tabs. My formula now looks something like this...=(tab1: cell a2+tab2:cell a2)
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Is there simple formula to add values from different tabs. My formula noe looks something like this...=(tab1: cell a2+tab2:cell a2)
Try this formula:
=tab1!A2+tab2!A2
Hope this helps / Lars-Åke
Answer accepted by question author
Hi,
If you want to pick up the same cell from each tab, try this
=sum(first_tab:last_tab!A2)
So in your case it would be
=sum(tab1:tab2!A2)
Regards,
Ashish Mathur
Microsoft Excel MVP
"DAS Tony G" wrote in message news:a03b1540-07f7-4f6e-81c7-64582f792106...
Is there simple formula to add values from different tabs. My formula now looks something like this...=(tab1: cell a2+tab2:cell a2)
Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com
Hi,
Can you be a bit more specific about what it is you are trying to do?
Regards
Hi I know this is an old post but I am trying something similar only thing is I want data from every other tab and im struggling to do this on Excel 2013, any advice?
Lars,
Thank you! That is pretty much how I currently do this task, it can get pretty tedious sometimes.