I am using a simple excel credit/debit worksheet that is auto totaling in the last column. I have 5 or 6 entries a year and I would like to leave a blank row between years for grouping. When I leave a blank row the auto total function doesn't work, is there any way to correct this? My curent formula is:
=IF(ISERROR(IF(OR(D13,E13),((F12)+D13-E13),)),"",IF(OR(D13,E13),((F12)+D13-E13),))
Try this, if you have your outgoings starting in D4 and your incomings in E4, then put this in F4
=IF(D4=0,SUM(D4:E4),IF(E4=0,E4-D4,E4-D4))
then in F5
=IF(AND(D5="",E5=""),"",SUM($E$4:E5)-SUM($D$4:D5)) and formula fill down the column.
Does this help?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks