To evaluate formula, select the formula cell and go to Formula tab in ribbon.
There is 80% chance that you will get your formula working. If SUMIF is returning #N/A error or any other error, evaluate the formula.In this article we will discuss all the cases in which SUMIF function may not work and how you can get it working.īefore we discuss issue points with SUMIF function in detail, check these in your formula. There can be many reasons behind SUMIF's inaccuracy. It doesn't mean that it can't happen to experienced Excel players. This mostly happens when you are new t0 this function and haven't used it enough. You will notice that the SUMIF function is not working properly or returning inaccurate results.
But there are times when you will face some difficulties working with the function. The SUMIF function is a useful function when it comes to summing up values based on some given condition.
