Adding selected entries in columns in Excel

hillbilly · #5 07-16-2015, 01:07 AM

Quote:

Originally Posted by macropod

This would be easier if you attached an actual workbook. You do that via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.

That said, your formula might give you what you want if you change it from:
=Sum (B61:62 + B65:76)
to:
=Sum(B61:B62,B65:B76)

I should have expressed it as =SUM(B61: D62, B65: D76) My error but it works now happily

Thank you that works perfectly You have been a great help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down entries in table disappear when selected	rothbe	Word Tables	1	06-05-2015 05:04 PM
Print selected pages as per excel value	DingDang	Word	0	03-17-2014 02:14 AM
How to display ONLY columns A to I in excel?	officeboy09	Excel	6	11-05-2013 10:18 AM
Adding columns in specific rows only	mhays	Excel	5	01-17-2012 09:13 AM
Adding Image into a excel cell and adding a hyperlink to the image	saravananiyyanar	Excel	3	05-04-2011 08:31 AM