Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding Values From Different Tabs
Is there a way to add values from different tabs on the same spreadsheet? For example A2 from tab 1 and A2 from tab 2 -- Flipkid2 ------------------------------------------------------------------------ Flipkid2's Profile: http://www.excelforum.com/member.php...o&userid=17984 View this thread: http://www.excelforum.com/showthread...hreadid=398184 |
#2
|
|||
|
|||
Assuming the name on Tab 1 is Sheet1 and Tab 2 is Sheet2, use this formula: =Sheet1!A2+Sheet2!A2 note the name of the sheet is followed by "!" to indicate it is a sheet name. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=398184 |
#3
|
|||
|
|||
one way:
='tab 1'!A2 + 'tab 2'!A2 (where "tab 1" and "tab 2" are the names of the worksheets in the same workbook). You could also use something like: =SUM('tab 1:tab 2'!A2) Note that this formula will include any worksheets from tab 1 to tab 2, left-to-right, inclusive, so if tab 3 were moved between tab 1 and tab 2, tab 3's A2 would be summed as well. In article , Flipkid2 wrote: Is there a way to add values from different tabs on the same spreadsheet? For example A2 from tab 1 and A2 from tab 2 |
#4
|
|||
|
|||
Thanks!!! Worked perfectly -- Flipkid2 ------------------------------------------------------------------------ Flipkid2's Profile: http://www.excelforum.com/member.php...o&userid=17984 View this thread: http://www.excelforum.com/showthread...hreadid=398184 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding values from previous worksheets | Excel Worksheet Functions | |||
adding values across worksheets in a spreadsheet | Excel Worksheet Functions | |||
Adding values for prior date intervals | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions | |||
Adding logical values | Excel Discussion (Misc queries) |