Hi I am trying to create a template to have a cell where I can enter my pay like D5 and below in like D7 through D16 list my various monthly bills amounts and have it subtract them from the balance of my pay in d5, I have tried doing this however I keep getting iterative error and it will not let me do it, anyone able to help me? I have search and found subtracting from a fixed number which I have found =2000-sum(d7:d16) which works and doesn't create any error however I would like to be able to be able to enter what ever number instead of a fixed number.
Thanks
Tim
Bookmarks