in the cell where you want the answer put =, then click on the tab and the
cell of the first figure the press + and click on the next tab and cell
untill tou have all the cells you want then click on the green tick next to
the formla bar. you will get a formula like =Sheet2!A1+Sheet3!A1
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"melisa0820" wrote:

HI all!

i have a workbook that i have been working on and i have one sheet that has
a bunch of totals

How do i "add up the 5 different cells" from one page and put the "answer"
on a seperate page?