In this tutorial we are going to use IF, SUMPRODUCT, and ISNUMBER to figure out the difference between summing values that add up to zero vs. summing blank cells in Excel.
Often in formulas in Excel, we use double quotes to indicate a blank. But in Excel, double quotes do not generate true blank cells. How can we get true blank cells without formulas in Excel? This tutorial will take you through the steps to accomplish this, plus show you a few other valuable tricks like […]