How to calculate YTD totals

[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

 

[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)

 

[surelle]

thanks BO