Help to make range of sum

[dodde]

Hello

I try to learn a little her, as i read this line it sum in row 4 and column 4, or am i wrong

i try to add colum 191, 197 and 199 ,

but i get some error when i try

Please Login or Register  to view this content.

Here is the whole vba

Please Login or Register  to view this content.

[mjr veverka]

Could you prepare some sample false data, but showing their true layout in the spreadsheet ?

[dodde]

Hello

yes sum are in bold text

[mjr veverka]

For example:

Please Login or Register  to view this content.

[dodde]

Hello

Thank you it works great, but i come up with a problem, if i have text in column C and sometime i have, it mess up, and can it also sum column HD and HF,

i have now make WB here as an total example

I modify it littlebit

Please Login or Register  to view this content.

[dodde]

Hello

it seems now that the problem i had with column c is gone with some more testing, but i still not can get it to sum Column "D", "HD" and "HF" both rsum and tsum, so i need some help

[dodde]

Hello

Is there anyone who can explain to me how to sub-sum and total sum in several columns, this applies to column D, HD, and HF

i have try several ways but failed

Please Login or Register  to view this content.

[dodde]

Hello

I lift this up in hope to get some help