MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sums for each cell in a column


Posted by Ben on October 11, 2001 11:17 AM

How can I apply a sum to a column so that each cell adds the cells in that row?


Posted by Aladin Akyurek on October 11, 2001 12:31 PM

=SUM(B1:INDIRECT(ADDRESS(ROW(),256)))

Is this what you are looking for?

Aladin