Forum Discussion
Numbers not showing on my excel sheet
Hello everyone. I was wondering if anyone has experienced my problem. I am working on a excel spread sheet, where I have a starting total ( my sales) and a long list of expenses. As I group the ex...
You mention a 'simple' formula
=D123-C122
I tend to describe such normal spreadsheet formulas as 'primitive' because the result of using the 'house of cards' built from the formula can be anything but simple. Basic worksheet operations like 'drag and drop' or deleting rows can disrupt the formula.
I would suggest repairing the formula by sending it down the entire column is necessary before you can trust any result it provides. Other approaches include the use of SUMIFS to sum the expenses over all earlier dates but that gets computationally expensive if you go beyond a few thousand lines.