Accounting is a vast field and as such has a lot of data available which you can use to generate various types of report as per your requirement. In this regard, if you can take support from Excel, it would be beneficial for you in many aspects. It will save your time, effort and reduces the chances of mistakes that could happen if you do the things manually. In this regard, an important formula in Excel is SUMIF which helps a lot in circumstances where you want to sum amounts found in different cells and sheets or even in files. As the data is not at one place, you cannot add them with a single click. Here you have to take support from SUMIF function.
SUMIF( range, criteria, [sum_range] )
TUK is a paper production company for industrial use. Its data entry operator maintains a spreadsheet which records sales everyday when it occurs of various products in the following format: