In Microsoft Excel, use the SUMIF function to sum the values in a range that meet the criteria that you specify. 

For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.