Skip navigation

All cells in a column not added by the final cell

220 Views 3 Replies Latest reply: Nov 6, 2012 6:28 AM by Simon De Trey -White RSS
Simon De Trey -White Calculating status...
Currently Being Moderated
Nov 5, 2012 7:07 PM

Hi I have a vary basic sheet of accounts with several columns including a column of figures that need to be totalled by a last cell in the same column.   I have 25 odd currency figures in the column that are totalled correctly by the final cell, but four or 5 cells below the 25 but above the cell configured to add them are not being included, how do I get them to be included? When I click on the final cell the 25 cells are selected and added but the others below are not highlighted in blue.

 

Thanks

 

Simon

MacBook Air (11-inch, Mid 2012), Mac OS X (10.7.4)

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.