done a basic ‘google sheets’ spreadsheet to help my wife sort her self employment account out.
shes just filling in her return now, and i realised i hadnt got a formula sorted to add all the different sheets up into one grand total. ive done it manually now, but i thought id put a formula in to automatically do it for future years.
the tabs are called January 2017, February 2017 etc etc for the whole year. i googled how to do this and came up with this formula…..
=SUM(January 2017!C17,February 2017!C18,March 2017!C23,April 2017!C27,May 2017!C18,June 2017!C25,July 2017!C25,August 2017!C25,September 2017!C25,October 2017!C25,November 2017!C25,December 2017!C25)
…..where the cell holding the individual total is C17, C18 on next one etc.
however, the cells come up with an error stating “Formula parse error”
i cant see any obvious mistakes, but can you tell me where im going wrong please?
thanks
EDIT: realised later id be better doing april to april rather than jan to jan but i can amend that if i get this formula business sorted.