I have a website that gathers information on a webform. This webform has fields that have numerical values associated with them. When I download the submissions to an excel file it puts each submission in its own row. As such, if I were to create a "total" cell through the webform, it would be something like "=f2*g2" which works. However, and there's always a however, that would only work for the very first entry and the subsequent submissions would all be "=f2*g2". I'm looking for a way for the cell to be changed based on the row number WITHOUT touching excel.

I hope that makes sense. I am trying to get my webform to plug in the right formula when it is exported to excel and account for the row that each submission is in.

I've tried things like: ="f"$row() but that just gives me a cell that says eg.. "f4"

Any help would be great!!
Thanks in advance.