View Single Post
  #10   Report Post  
topola
 
Posts: n/a
Default

My pleasure indeed. See the following:

V_RNG = A1:X100 '$Value Range

S_RNG = A200:X200 'Visible $Status
A200 = CELL("width",A$1)

AA1:AA100 'Simple Sum
AA1 = SUM(A1:X1)

AB1:AB100 'Visible Sum
AB1={SUM(IF(S_RNG0,A1:X1,0))}

AC1:AC100 'Sum Checking = Simple Sum Minus Visible Sum
AC1=IF(ROUND(AA1-AB1,2)=0,"ok","BAD")

AD1:AD100 Point Hidden Columns - Sums the number of Wrong Hidden
Columns
AD1={SUM(IF(S_RNG=0,IF($A1:$X1<0,COLUMN($A1:$X1), 0),0))}

AD1:AD100 Point Hidden Columns - Counts the Wrong Hidden Columns
AD1={SUM(IF(S_RNG=0,IF($A1:$X1<0,1,0),0))}

It makes me feel much more comfortable now.
__
Tomek Polak
Enterprise Investors