LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Jeanne
 
Posts: n/a
Default

Sorry, hit the enter key before completion. Dave, you are correct on your
explanation for x-foot. However, Brian's solution does not work. Here is an
example in column two of what I want to see as a result of column one:

123,456.78 123
123,456.78 123
123,456.78 123
123,456.78 123
123,456.78 123
123,456.78 123

740,740.68 738 Total of above column

Any advises are greatly appreciated. Have a great day.

Jeanne

"Dave O" wrote:

X-foot is shorthand for "cross foot", meaning the sum should be the
same whether you add the elements horizontally or vertically. It's a
checksum process to ensure accuracy.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I convert every cell in a spreadsheet to round to millions How2round Excel Worksheet Functions 3 June 8th 05 06:42 PM
How do i round up a price to the nearest 5,10,15 etc pence Millsy Excel Worksheet Functions 1 May 18th 05 02:20 PM
How do I format cells to round to the nearest thousands without .. excel user Excel Discussion (Misc queries) 1 March 16th 05 08:10 PM


All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"