Thread: [Solved] How to obtain a column total using only specific cells
View Single Post
 
Old 03-20-2015, 05:29 AM
Jo Freeman Jo Freeman is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Mar 2015
Posts: 19
Jo Freeman is on a distinguished road
Default
Hello Snakehips

Thank you for your reply, but I still can't get it to work. I have converted the spreadsheet to a table and tried the SUMIF formula but when I insert new lines, my total column doesn't update to include the new line.

My original IF formula was =IF(H86>0,0,D86) ie, if H86 contains a figure, don't include the value of D86 in the total. Can you help me with the equivalent SUMIF formula please?

Many thanks
Reply With Quote