How do I get a formula to increment to the next row?

quasarn01

I'm putting in a formula, let's say, cell F2, example: =SUM(C2+D2), and I want that formula to increment in cell F3 to be =SUM(C3+D3)... I can't seem to figure out how to do this... I am proficient in Excel and I've tried duplicating the row, however, it just copies the first formula into the next row without incrementing... I've read this forum from top to bottom and searched the main pages for this process but to no avail. I'll have hundreds of rows and, short of having to go in and edit each row, I was hoping to find a way to do it automatically...

allan

Its not really something DataTables attempts to provide. It is technically possible using the meta data that is passed in as the fourth parameter to the columns.render function, but you'd need to invalidate all of the rows every time the table is sorted or filtered, which is a significant performance drag.

Allan