ExcelBanter - How do I get the total of a range of cells that are in another she

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I get the total of a range of cells that are in another she (https://www.excelbanter.com/excel-discussion-misc-queries/57118-how-do-i-get-total-range-cells-another-she.html)

alice

How do I get the total of a range of cells that are in another she

I have two sheets in the workbook and I need to get the total of a range in
sheet1 into a table on sheet2. How do I go about this?

bob777

How do I get the total of a range of cells that are in another she

something like
=sum(sheet2!$a$1:$a$5)

note the ! after the sheet name

bobf

--
bob777
------------------------------------------------------------------------
bob777's Profile: http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=487937

All times are GMT +1. The time now is 10:23 PM.