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

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

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

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