How to calculate YTD totals

S

surelle

If I have one set of figures on wksheet1 (eg a qtr), and another o
wksheet 2 (the next qtr), how can I consolidate the 2 sets of figure
to be a year to date total on a 3rd wksheet?:confused
 
B

Bob Phillips

Something like

=SUM('Sheet1'!A1,'Sheet2'!A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top