Why wont this work?

Copper Contributor

=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 :)

3 Replies

@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.

@Riny_van_Eekelen  thank you so much, it worked :)

@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.