How to use a SUMIF Formula

How to use a SUMIF formula in Excel with an example

Do you need help with a SUMIF Formula in Excel. Here is a step by step explanation and example that can help you.

A SUMIF function is a great way summing up data that meets a criterion.
The SUMIF formula enables you to sum up a column if a condition is met, e.g. add up all costs relating to food, or add up all the expenses that related to HR.

Here is an example of a SUMIF where we will find out the total expenses relating to people who work in HR.

SUMIF Excel example

sumif formula

There is also a formula called SUMIFS, which you use if want to add up the data if two criteria are met, eg work in HR and in London.

If you want help with a SUMIFS then please get in touch.

A common alternative to a SUMIF is the use of Pivot Tables, albeit Pivot tables can do a lot more than a SUMIF.

For help with SUMIF formulas then click here to contact us.

Unlike most Excel spreadsheet training courses - we will not provide generic Excel spreadsheet training instead each course will be tailored to needs of the group - with the agenda set by the people attending the course.

This training is suitable for employees from all departments and levels of experience.

Training for PCs or Macs.

Global training via Teams, Skype or Zoom

Training available in:

Office 365
Microsoft Excel 2016
Microsoft Excel 2013
Microsoft Excel 2011
Microsoft Excel 2010
Microsoft Excel 2007

Meet Your Instructor, Gina Cohen

Microsoft Excel, PowerPoint, Word, Outlook and Teams trainer and Spreadsheet Consulting specialist with eleven years experience in the Finance department at Morgan Stanley. Has been teaching and consulting since 2013.

Get In Touch


07887 552 045

Gina Cohen
Scroll to Top