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.
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:
Microsoft Excel 2016
Microsoft Excel 2013
Microsoft Excel 2011
Microsoft Excel 2010
Microsoft Excel 2007
"Gina - you are an Excel Genius! Thank you so much! The spreadsheet is all up and running now."
1-2-1 Excel Consulting Client
Meet Your Instructor, Gina Cohen
Microsoft Excel & PowerPoint training and Spreadsheet Consulting specialist with eleven years experience in the Finance department at Morgan Stanley.
Get In Touch
07887 552 045