modulable dynamic macro to sum amount in contigious and non contigious columns

[RAM72]

Looking for a dynamic macro to add amount in contigious and non contigious columns .

So depending of requirements column K,L,M,N,Oand R may have data for summing.

However column K ,L,O and R may need summing but to take in account that there may be blank cells among the columns.
See attached

No of rows may vary from 30 to 15000 rows

 

[Deepak]

RAM72

Why have you taken to sum from row 51 in all columns.

 

[RAM72]

RAM72

Why have you taken to sum from row 51 in all columns.

oopps aplogize an insight reloaded file with correct ranges

 

[Nebu]

Hi:

I am afraid whether I completely understood you. However, from what you uploaded you can get the expected result by simply converting your data into a table. Find the attached.

Thanks

 

[RAM72]

Hi:

I am afraid whether I completely understood you. However, from what you uploaded you can get the expected result by simply converting your data into a table. Find the attached.

Thanks

Indeed am doing this for low skilled users and some people are using excel 2003 so they mess up a lot with formulas
So this why am looking for a macro

 

[Nebu]

Hi:

I have not given any formula, its an in-build feature of the tables, if you highlight the total column you will get a drop down you can select a variety of calculation from this drop down.

Thanks