Sumif is one of the most used formulas within excel - and for good reason. It is also one of the most powerful and time savings functions you can learn. This video tutorial will teach you the following:
1) sumif formula.
2) BONUS 1: How to change values in a cell combining the use of a drop down list and the sumif formula
3) BONUS 2: How to use conditional formatting to turn a cell different colors based on the value created by the sumif formula.
If you learn something (even 1 thing), please leave a comment letting me know!