Forum Discussion
How to subtract rows?
I have looked everywhere for the answer to this extremely simple question. All cells have numeric values. How do automatically I subtract row 23 from row 24 across ALL cells?
I am assuming that you have data arranged in rows. The first row is 23 and the second one is 24. Let's assume that you want to get a difference of cells (A to E) in row 23 from cells in row 24. You can use this array formula in row 25.
=(A24:E24 - A23:E23)
If you are using Excel 2019 or earlier then you might have to select all cells from A to E in row 25 and then enter this formula by pressing CTRL+SHIFT+ENTER.
I hope this helps.