Why wont this work?

%3CLINGO-SUB%20id%3D%22lingo-sub-1595043%22%20slang%3D%22en-US%22%3EWhy%20wont%20this%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595043%22%20slang%3D%22en-US%22%3E%3CP%3E%3DSUM(I28%2B'WE%2017%20Jun%2020'!I28%2B'WE%203%20Jun%2020'!I28%2B'WE%2020%20May%2020'!I28%2B'WE%206%20May%2020'!I28%2B'WE%2022%20Apr%2020'!I28%2B'WE%208%20Apr%2020'!I28%2B'WE%2025%20Mar%2020'!I28%2B'WE%2011%20Mar%2020'!I28%2B'WE%2026%20Feb%2020'!I28%2B'WE%2012%20Feb%2020'!I28%2B'WE%2029%20Jan%2020'!I28%2B'WE%2015%20Jan%2020'!I28%2B'WE%201%20Jan%2020'!I28%2B'WE%2018%20Dec%2019'!I28%2B'WE%204%20Dec%2019'!I28%2B'WE%2020%20Nov%2019'!I28%2B'WE%206%20Nov%2019'!I28%2B'WE%2023%20Oct%2019'!I28%2B'WE%209%20Oct%2019'!I28%2B'WE%2025%20Sep%2019'!I28%2B'WE%2011%20Sep%2019'!I28%2B'WE%2028%20Aug%2019'!I28%2B'WE%2014%20Aug%2019'!I28%2B'WE%2031%20Jul%2019'!I28%2B'WE%2017%20Jul%2019'!I28%2B'WE%203%20Jul%2019'!I28%2B'WE%201%20Jul%2020'!)%3C%2FP%3E%3CP%3EOr%20please%20tell%20me%20how%20to%20add%20the%20same%20cell%20across%20several%20sheets%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1595043%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1595314%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20wont%20this%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%20thank%20you%20so%20much%2C%20it%20worked%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1595055%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20wont%20this%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595055%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762706%22%20target%3D%22_blank%22%3E%40NannaSal%3C%2FA%3E%26nbsp%3BTry%20this%20in%20stead%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUM('Sheet%201%3ASheet%203'!I28)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3Bwhere%20%22Sheet%201%22%20represents%20the%20name%20of%20the%20first%20tab%20you%20want%20to%20include%20and%20%22Sheet%203%22%20the%20name%20of%20the%20last%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1595335%22%20slang%3D%22en-US%22%3ERe%3A%20Why%20wont%20this%20work%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1595335%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F762706%22%20target%3D%22_blank%22%3E%40NannaSal%3C%2FA%3E%26nbsp%3BGlad%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBy%20the%20way%2C%20your%20original%20formula%20could%20have%20worked%20if%20you%20had%20included%20%22I28%22%20at%20the%20far%20end.%20You%20formula%20ended%20with%20%22%3CSPAN%3E%2B'WE%201%20Jul%2020'!)%22.%20It%20should%20have%20been%20%3C%2FSPAN%3E%3CSPAN%3E%22%2B'WE%201%20Jul%2020'!I28)%22.%26nbsp%3B%3C%2FSPAN%3EBut%20it's%20not%20the%20most%20effective%20way%20to%20do%20it%20like%20that%2C%20of%20course.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.