Forum Discussion
Help with IF statements
HansVogelaar Thanks so much for helping me solve this, I'd like to ask another question if it isn't too much trouble for you. I have another column that records the profit from each sale and I would like to have a cell at the bottom of it that displays the total profit. Is there a way to automatically sum the column and display it in said cell without having to change the whole formula every time a new row is added in the spreadsheet?
There are several ways you can do that:
1) Let's say that your data are in M2:M50.
Leave row 51 empty.
In M52, enter the formula = SUM(M2:M51)
When you need to add a new row, insert it in row 51. Excel will automatically update the formula to =SUM(M2:M52)
2) Convert your data to a table (Insert tab of the ribbon > Table).
You can add a Total row to the table and specify Sum as summary function.