This will return the sum of the values within a desired range of cells that all meet one criterion. For example, would return the sum of values between cells C3 and C12 from only the cells that are greater than 70,000. Let's say you want to determine the profit you generated from a list of leads who are associated with specific area codes, or calculate the sum of certain employees' salaries -- but only if they fall above a particular amount. Doing that manually sounds a bit time-consuming, to say the least.
With the SUMIF function, it doesn't have to be you can easily add up the sum of cells that meet certain criteria, like in the salary example above. The formula: =SUMIF(range, criteria, sum_range Range: The range that is being tested fax number list using your criteria. Criteria: The criteria that determine which cells in Criteria_range1 will be added together [Sum_range]: An optional range of cells you're going to add up in addition to the first Range entered. This field may be omitted. In the example below, we wanted to calculate the sum of the salaries that were greater than $70,000.
The SUMIF function added up the dollar amounts that exceeded that number in the cells C3 through C12, with the formula SUMIF formula in Excel 12. TRIM The TRIM formula in Excel is denoted remove any spaces entered before and after the text entered in the cell. For example, if A2 includes the name " Steve Peterson" with unwanted spaces before the first name, =TRIM(A2) would return "Steve Peterson" with no spaces in a new cell. Email and file sharing are wonderful tools in today's workplace. That is, until one of your colleagues sends you a worksheet with some really funky spacing.