Thanks alot!!!

I'm sorry but I am not seeing the file

All of my cells do have the same name. I used your code but it only does it for row1...I have 3 rows, how do I get it to calculate all the cells in that column?

I try to sum the values of a column and display it in the footer row but not success it. Any advice?I've tried adding the rows individually "cell2[0]+cell2[1]+cell2[2]" and I tried summing the "sum(cell2[*])"