Calculate Percentage for matrix data

[rajamdade]

Below is the sample of data in matrix form (4000x4000), i need to find out percentage as shown:

[TABLE="class: grid, width: 832"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]GBCAT-1[/TD]
[TD="width: 64"]GBCAT-2[/TD]
[TD="width: 64"]GBCAT-3[/TD]
[TD="width: 64"]GBCAT-4[/TD]
[TD="width: 64"]GBCAT-5[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]%[/TD]
[TD="width: 64"]GBCAT-1[/TD]
[TD="width: 64"]GBCAT-2[/TD]
[TD="width: 64"]GBCAT-3[/TD]
[TD="width: 64"]GBCAT-4[/TD]
[TD="width: 64"]GBCAT-5[/TD]
[/TR]
[TR]
[TD]GBCAT-1[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.226[/TD]
[TD="align: right"]0.234[/TD]
[TD="align: right"]0.216[/TD]
[TD="align: right"]0.248[/TD]
[TD][/TD]
[TD]GBCAT-1[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[/TR]
[TR]
[TD]GBCAT-2[/TD]
[TD="align: right"]0.226[/TD]
[TD="align: right"]0
[/TD]
[TD="align: right"]0.235[/TD]
[TD="align: right"]0.208[/TD]
[TD="align: right"]0.194[/TD]
[TD][/TD]
[TD]GBCAT-2[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[/TR]
[TR]
[TD]GBCAT-3[/TD]
[TD="align: right"]0.234[/TD]
[TD="align: right"]0.235[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.21[/TD]
[TD="align: right"]0.249[/TD]
[TD][/TD]
[TD]GBCAT-3[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[/TR]
[TR]
[TD]GBCAT-4[/TD]
[TD="align: right"]0.216[/TD]
[TD="align: right"]0.208[/TD]
[TD="align: right"]0.21[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0.195[/TD]
[TD][/TD]
[TD]GBCAT-4[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[/TR]
[TR]
[TD]GBCAT-5[/TD]
[TD="align: right"]0.248[/TD]
[TD="align: right"]0.194[/TD]
[TD="align: right"]0.249[/TD]
[TD="align: right"]0.195[/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD]GBCAT-5[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[TD]%[/TD]
[/TR]
</tbody>[/TABLE]


Please suggest formula or script, thank you!

 

[shg]

Percentage of what? Give some examples.

 

[rajamdade]

Hello Shag! thanks for giving your time... percent of the total!

 

[shg]

Percent of the total of all 16 million cells?

 

[rajamdade]

Now, Ive got an alternative software to do that work! Thanks shg for your time!