How to calculate YTD totals

  • Thread starter Thread starter surelle
  • Start date Start date
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
 
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)
 
Back
Top