in my project there are nine formulas's , the values(output) will be either 1 or zero.

i need to write one more formula i.e. it sholud coumnt all these i.e.

R1=1

 R2=1 , R3=1 ,R4=1  ,R5=1 ,R6=1 ,R7=1 ,R8=1 ,R9=1 

 

then Count all these i need to get answer as "9".. but how to write formula for this??????

 

 

otherwise how to write one formula which combines all these 9 formulas???

 

actually these fields(i.e R1,R2 etc ) detemines which account number appeared on which report????

actually der are nine reports all are interlinked..

 

 

 

Hi All,

 

I got to know this problem should be solved by using global variabl.. plz can u tell me idea how to use????