Convert from the sum table from 1 to 9 each number in the draw line *

[jack]

Convert from the sum table from 1 to 9 each number in the draw line
* The value 00 (can set zero (0) in the positions
http://www.mediafire.com/file/ffsu0fva3tjm77s/pasta_soma_9_exfora_zero.xlsx

 

[jack]

we have 9 sums, the makro has to look at each corresponding sum per line

 

[jack]

=if(mod(a5,9),mod(a5,9),9)*(a5>0)