Sum value of last column

[hanif]

Hi all,

I have the below code to sum a range of values in the last colum but it does not work! does anyone know where am I going wrong?

Please Login or Register  to view this content.

Thanks

[oeldere]

This looks a duplicated post to me.

http://www.excelforum.com/excel-prog...9177-name.html

If so,mark the other question solved.

[TMS]

Please post a sample workbook with some typical data and indicate your expected outcome.

[hanif]

I have attached a sample spreadsheet. If you look at sheet2 I am trying to get sum of H3:H14 in cell H15 but instead of Range H3:H14 I would like to use the range of row 3 value of the las column and row 14 value of the last column.

[hanif]

Thank you all for your replies was able to fix it

[oeldere]

then show us your result, so other forummembers also can learn from it.

[hanif]

This is right code for that:

Please Login or Register  to view this content.