Aug 17 2020 09:58 PM
=SUM(I28+'WE 17 Jun 20'!I28+'WE 3 Jun 20'!I28+'WE 20 May 20'!I28+'WE 6 May 20'!I28+'WE 22 Apr 20'!I28+'WE 8 Apr 20'!I28+'WE 25 Mar 20'!I28+'WE 11 Mar 20'!I28+'WE 26 Feb 20'!I28+'WE 12 Feb 20'!I28+'WE 29 Jan 20'!I28+'WE 15 Jan 20'!I28+'WE 1 Jan 20'!I28+'WE 18 Dec 19'!I28+'WE 4 Dec 19'!I28+'WE 20 Nov 19'!I28+'WE 6 Nov 19'!I28+'WE 23 Oct 19'!I28+'WE 9 Oct 19'!I28+'WE 25 Sep 19'!I28+'WE 11 Sep 19'!I28+'WE 28 Aug 19'!I28+'WE 14 Aug 19'!I28+'WE 31 Jul 19'!I28+'WE 17 Jul 19'!I28+'WE 3 Jul 19'!I28+'WE 1 Jul 20'!)
Or please tell me how to add the same cell across several sheets :)
Aug 17 2020 10:12 PM - edited Aug 18 2020 01:17 AM
@NannaSal Try this in stead:
=SUM('Sheet 1:Sheet 3'!I28)
where "Sheet 1" represents the name of the first tab you want to include and "Sheet 3" the name of the last one.
Aug 18 2020 01:25 AM
@NannaSal Glad I could help.
By the way, your original formula could have worked if you had included "I28" at the far end. You formula ended with "+'WE 1 Jul 20'!)". It should have been "+'WE 1 Jul 20'!I28)". But it's not the most effective way to do it like that, of course.