How to use SUMIF

Thanks! Share it with your friends!


We like this video as it shows you how to use SUMIF at a good and steady pace and it also talks about the importance of using the $ sign in your equation.

The SumIF function is another great function to help you build spreadsheets that work out of the box for your users. Make sure you build your equations to take into account any expansion of your data that may happen in the future.

SUMIFis very useful if you are looking to make a spreadsheet that works for every user that uses it, however if you are look for simple summing functions just for yourself then you need to check our pivot tables videos as these are very fast and require no equations!


Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.