Get instant live expert help on sumif not blank
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Sumif formula not working with multiple criteria
Solved by B. F. in 22 mins
Help with sumif formula not adding multiple columns
Solved by O. Q. in 17 mins
Not allowing me to combine a sumproduct and sumif function in excel. Both the sumproduct and sumif functions have multiple criteria
Solved by E. W. in 26 mins
sumif not working, formula is correct but due to list its not working
Solved by T. E. in 28 mins
Hello. I am looking to create a running balance in a column on an excel spreadsheet for an accounting bank statement, however I only want the balance to be calculated when the cells to be considered are not blank. I have tried sumif and sumifs but can't get either to work. This is what I am trying to achieve: Opening Balance C2 + Debit A3 - Credit B3 New Balance C3 = C2 + A3 - B3 (but only if A3 and B3 are not blank, if they are blank then the balance for that row to be left blank too).
Solved by K. H. in 21 mins