Using SUMIF in Excel - Top 5 Excel Features #2

In this video we'll give you a quick tutorial on how to use SUMIF and why it's worthy of the number 2 place in our top 5 best excel features list. Download the spreadsheet used in this video and see more tips at http://software-matters.co.uk/microsoft-excel-help-and-tips.html#excel. When you want to do a conditional sum (a sum where you only add entries for which a certain criteria is true) you need to use the SUMIF function. Combined with it's sister function SUMIFS, which lets you have many conditions, you can extract very specific information from a dataset of any size.

Get more help and advice on Excel, Access or VBA projects:
http://www.software-matters.co.uk/youtube_links.html

Music:
Local Forecast - Kevin MacLeod
http://incompetech.com/
---------------------------------------------
If you found this video helpful, please consider giving it a Like, leaving a comment or sharing it.

More from the Software-Matters channel:
https://www.youtube.com/channel/UCk-MVP61VQHMdfETVNQEFww

Visit the Software-Matters website:
http://www.software-matters.co.uk/

Software-Matters is based in Gillingham, Dorset, in the south-west of the United Kingdom (UK), near Somerset, Wiltshire and Hampshire and the cities of Bournemouth, Poole, Southampton, Bristol, Bath and Salisbury.

Видео Using SUMIF in Excel - Top 5 Excel Features #2 канала Software-Matters