View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SillyLama SillyLama is offline
external usenet poster
 
Posts: 1
Default total two cells from one worksheet to one cell in another workshee

Sheets 1 & 2 are now called Invoice-1 & Invoice-2

Invoice-1: Cell G27 =SUM(E22:E26)
Invoice-1: Cell G37 =SUM(E33:E37)
(of course, the amounts in E cells change with each invoice I create)

In Invoice-2 (cell G26) I need to put the total of cells G27 and cell G37
from Invoice-1. Can anyone advise as to how I can do this?