The SUMIF function is pretty versatile — you can use a number, text, or even a date as the criterion. Sum_range: The sum_range is optional, and is what gives this function so much power.

How to use the SUMIFS function in Excel. In this tutorial, we want to add the total number of sales of mangoes we made from, say, Kevin Sahadeo. Click the cell where you want the result to be.

Say you want to calculate the total sales for each member of a team, but your GL or other enterprise system can’t do the job. So you export the relevant data into Excel, where you use the SUMIF ...

In fact, you can use this function to sum all the negative or positive values in the same range. Sum. First, let’s take a brief look at SUMIF().

For more details, use cases, and best practices for all four of these functions, see Microsoft’s SUMIF, SUMIFS, COUNTIF, and COUNTIFS support pages. 4. The CONCAT function ...

I keep running into situations in Excel where I want to calculate a conditional sum, but my criterion is something along the lines of "Include cell B1 if cell A1 is a number, likewise B2 and A2 ...

Pivoting the data produces the answers I seek, but the report is a mile long and difficult to navigate. It doesn’t seem necessary to produce more than 100,000 values via a PivotTable when I need only ...

Excel’s SUMIF() and COUNTIF() are two of my favorite summarizing functions and we’ve talked about both frequently in this blog. What we haven’t discussed is how to return a conditional average.

I use it all the time because I love spreadsheets—it’s part of the core of who I am. In fact, I reconcile my bank account every day in a spreadsheet and use the SUMIF function to weed out the ...