LinkBack URL
About LinkBacks
I am consolidating all excel sheets but it shows error in formula, i want to know what is the error
I am consolidating all excel sheets but it shows error in formula, i want to know what is the error
Hi maddy,
Try this:
=SUM('Mdu Rural'!C2+Dindigul!C2+Theni!C2+Dhar!C2+Kanchi!C2+Thiruvallur!C2+Cuddalore!C2+Adilabad!C2+Chittoor!C2+Tanjore!C2+Mysore!C2+Salem!C2+'Mdu Urban'!C2)
If there is a space in the sheet name you need the single quote around the name. If there is no space you don't need the single quotes.
Also you can do your 3D sum using this formula:
=SUM('Mdu Rural:Mdu Urban'!C2)
Read about it at:
http://www.excel-exercise.com/function/3d/
Last edited by MarvinP; 05-23-2017 at 01:23 AM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
thanks alot thread solved
=SUM(Mdu Rural!C2+Dindigul!C2+Theni!C2+Dhar!C2+Kanchi!C2+Thiruvallur!C2+Cuddalore!C2+Adilabad!C2+Chittoor!C2+Tanjore!C2+Mysore!C2+Salem!C2+Mdu Urban!C2) wrong
=SUM('Mdu Rural'!C2+Dindigul!C2+Theni!C2+Dhar!C2+Kanchi!C2+Thiruvallur!C2+Cuddalore!C2+Adilabad!C2+Chittoor!C2+Tanjore!C2+Mysore!C2+Salem!C2+'Mdu Urban'!C2) correct
**Inverted commas for the first and last additions are missing
=SUM('Mdu Rural:Mdu Urban'!C2)
This is easier than above as the sheets are continuous and the value you need to add was in the same cell of the different sheets
Use Shift for this click on First Number on First sheet and then Press Shift Key + Last Worksheet till where you need the addition.
Hi rajuisvn and thanks for the help,
I looked all over for those "Inverted Commas" and finally realized what you meant. In the USA we call those "Single Quotes" or "Apostrophes". You've added to my vocabulary now.**Inverted commas for the first and last additions are missing
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks