Get instant live expert help on sumif excel 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
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
To group and total values in excel:
Formula not allowed.=SUMIF(A2:A10,"A2", B2:B10).
Excel rejects with message: problem with the formula
Tried to include " in front of = as per excel advise.
" =SUMIF(A2:A10,"A2", B2:B10)
Also tried:
=SUMIF($A$2:$A$10,"A2", B2:B10)
Solved by T. H. in 27 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
excel formulas not working, formula is correct but due to list its not working
Solved by T. E. in 28 mins
how to use excel sumif multiple criteria and whats the difference between Pivot table sumif?
Solved by E. J. in 12 mins