Thread: Summation Puzzle
2011-12-06, 20:40 #1
- Join Date
- Feb 2001
- New York, New York, USA
- Thanked 0 Times in 0 Posts
I have 200 vectors that I want to sum. Each vector has its own currency and there are 2 basic ways of looking at the vectors (sum by X, sum by Y, grand total).
I want to add check sum so that I can tell at a glance that I have all of the vectors, I haven't missed any and I haven't double counted any. I need to be able to do this when I sum over X, over Y and in total.
What is the best way to construct such a check sum?(Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
Quote: "All Happiness is the release of internal pressure"
Subscribe to our Windows Secrets Newsletter - It's Free!
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!