The SUMIF function is used to sum the values in a range that meet criteria that you specify. This builds on the SUM Function so make sure to view that video. We will get into some examples, tips, and tricks in this video.

My name is Tony and I have a degree in architecture and business administration. Excel is a powerful tool so don’t get discouraged. I’ve spent numerous hours, days, weeks working on my spreadsheets and years learning what I know. My hope is that my tutorials will be a quick way for you to learn what I know in a more condensed timeline.

The SUMIF function is a must know essential tool that can be used in numerous applications and workflows. See my courses page for advanced uses of this function in combination with other functions or the related videos section for similar functions.