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
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
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
Bruce
The older I get, the better I used to be.
USA
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 <[email protected]>,
Flipkid2 <[email protected]>
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks