So this is part three of a series of posts I am doing on creating a simple accounting system. Just a gentle reminder that if you think your business could grow – I would really recommend that you look at investing time and money into an actual accounting software package – it would already have a lot of the functionality built in. In Part One we looked at data entry and how important that is. In Part Two we looked at how to use a pivot table to summarize your data and in this blog post we are going to look at how to use a function called Sumifs to summarize your data. You can download the completed file here