|
|
#3
03-20-2015, 05:29 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Return Sum value of one column from cells not blank in another column | zulugandalf | Excel | 3 | 08-14-2014 03:37 AM |
 How obtain accurate total of hours estimated of all subtasks that are a certain type?
|
pcumming | Project | 3 | 05-14-2014 05:45 PM |
| How to obtain maximum value of an excel column with a large range? | sirkay | Excel | 4 | 02-23-2014 08:17 AM |
| How to obtain the column “C” from column “A” and “B”? | Jamal NUMAN | Excel | 2 | 02-26-2012 01:28 PM |
|
How to count the total cells that contains text data?
|
Learner7 | Excel | 1 | 06-30-2011 04:13 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode