• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUM won't fill down to new table row

K

kimbera68

New Member
I have a table with a column for a running balance. When I get to the last data cell in my table and tab to enter a new line, all the formulas fill down except the running balance. There is a SUM formula in the column next to it that fills down just fine.


Column L fills down: =SUM(Table26[@[Water Maintenance]:[Future Fund]])


Column M does not: =SUM(M11,[@[Transaction Total]])

note: (Transaction Total) is referencing the value in Column L above.


Can someone tell me how to fix this?


Thank you.
 
It seems I'm having the same problem on other sheets as well. Some formulas copy down some do not. My Data Validation List and an IF formula don't fill down, in another sheet one of my SUM formulas doesn't fill down, but another one does and the formula cell references have changes causing it to be inaccurate. Not sure what's going on with this.
 
Good day kimbera68


Do you have none showing data in cells that stop you copying down even a space in a cell will stop the formula from being copied dow to where you want it.
 
Thank you Bobhc. I think I figured it out while you were answering. I reapplied the formula to the entire table column instead of just highlighting a range and it works. That creates a different problem though because the first value in my columns is a balance forward and I want it ignored for my formulas. If I apply to the entire table column it includes this value.


For a SUMIF function is there a way to exclude the first cell in the column from the calculation? My formula is currently:


=SUMIF(Table912[02 Water Maintenance],"<0")
 
You must log in or register to reply here.
Back
Top