EXCEL: SUMIFS – DEMYSTIFIED


The Office Corner

AutoSumDon’t you just love SUM? The Excel development team does, they even gave it a huge button in the ribbon. If you need to sum up a range of numbers you just click the AutoSum button and you are done. Working with Sum just made our lives just that more convenient. So you are ready for the next steps with SUM and are looking for a sum of values based on a condition. Enter SUMIF. Note: my regional settings require a ; (semi column) as a argument delimiter. Depending on your settings this can also be a , (comma). So replace accordingly in your functions.

Conditional Summing

Ok, let’s see how this SUMIF function works. We have a small range in Excel and would like to sum the values based on a condition in that range. Take a look at the following scenario in the image below:
SumIfs_I

We see…

View original post 901 more words