How to use a SUMIF Formula

How to use a SUMIF formula in Excel

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

ginacohen2

Microsoft Excel & PowerPoint training and Spreadsheet Consulting specialist with eleven years experience in the Finance department at Morgan Stanley.

Get In Touch

PHONE

07887 552 045

Scroll to Top