View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F[_2_] Dave F[_2_] is offline
external usenet poster
 
Posts: 187
Default Creating the equivalent of a "hash code" for a workbook

On Dec 18, 3:17 pm, AMADHA wrote:
I have a need to create a single cell value that "sums" an entire workbook
and displays that sum. The goal is to have a quick way to determine if a
printed copy of the workbook matches the electronic version without scanning
each field manually by comparing the contents of just that one cell.

Any ideas?


=SUM(range1,range2,....) etc?

Am I missing something here?

Also, it's not clear that doing this will confirm that an electronic
version matches a digital version. If the value in cell A1 is
decreased by 1 and the value in B1 is increased by 1, the changes will
be a wash, and the sum will appear the same. But it's not the same
document.

Dave