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

alice · Nov 24, 2005

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 · Nov 24, 2005

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

note the ! after the sheet name

bobf