For large datasets, you may often need to calculate a total amount for a given range between two numbers. This can be easily done with the SUMIFS function both in Excel and Google Sheets. Continue reading
The SUMIF and SUMIFS functions available in Microsoft Excel and Google Sheets are case-insensitive by nature. To conditionally sum cells treating lowercase and uppercase letters as different characters, you'll have to come up with something else. Continue reading
In some situations, you may need to sum specific numbers in a range, say top 3, 5, 10 or n. That might be a challenge because Excel has no inbuilt function for this. But as always, there is nothing that would prevent you from constructing your own formulas :) Continue reading
Doing a conditional sum in Excel is a piece of cake as long as all the values to be totaled are in one column. Summing multiple columns is a problem because both the SUMIF and SUMIFS functions require the sum range and criteria ranges to be equally sized. Continue reading
Working on a report, investment plan or any other dataset with dates, you may often need to sum values within a specific period. This tutorial will teach you a quick and easy solution - SUMIFS formula with date range as criteria. Continue reading
Microsoft Excel has a special function to sum cells with multiple conditions and the AND logic - the SUMIFS function. In some situations, however, you may need to sum with multiple OR criteria. And this is when the SUMIF function comes in handy. Continue reading
Google Spreadsheets provide two functions to conditionally sum cells, SUMIF and SUMIFS. Regular visitors of our blog are already familiar with the SUMIF function that we covered last week, and today we are going to have a closer look at its plural version. Continue reading
Google Sheets has two functions to add up numbers based on conditions: SUMIF and SUMIFS. The former evaluates just one condition while the latter can test multiple conditions at a time. In this tutorial, we will focus solely on the SUMIF function. Continue reading
In our previous tutorial, we were looking at Excel If contains formulas that return some value to another column if the target cell contains a specific value. Aside from that, what else can you do if a cell contains certain text or number? Continue reading
Did you know that Excel SUM is the function that people read about most? No wonder they decided to add a special button to the Excel ribbon that inserts the SUM function automatically. So, if you wanted to know "What is AutoSum in Excel?" you already got the answer. Continue reading
The tutorial shows the most effective ways to use Excel's AutoSum feature and write your own Sum formulas to total a column, rows or selected range. You will also learn how to sum only visible cells, calculate running total and find out why your Sum formula is not working. Continue reading
This tutorial explains the difference between the SUMIF and SUMIFS functions in terms of their syntax and usage, and provides a number of formula examples to sum values with multiple AND / OR criteria in Excel. Continue reading
If you are faced with a task that requires conditional sum in Excel, the SUMIF function is what you need. It is a really great function that can help you make sense of an incomprehensible set of diverse data. Instead of adding up all numbers in a range, it lets you sum only those values that meet your criteria. Continue reading
In this tutorial, you will find a handful of advanced formula examples that demonstrate how to use Excel's VLOOKUP and SUM or SUMIF functions to look up and sum values based on one or several criteria. Continue reading