Adding amounts greater than zero
Adding amounts greater than zero or another given value in Excel is sometimes required and can be acquired by using the SUMIF or SUMIFS formulas. The formula for adding amounts greater than a given value =SUMIFS(sum range, sum range, “>0”) You can replace 0 with the value you need. The condition inside the formula can […]
Find and delete duplicates in Excel
In order to find and remove duplicates or just highlight them in an complex and messy Excel spreadsheet be prepared to work hard or just smart and elegant. Too many times we end up with an extralarge Excel file that contains some very complex information and a lot of duplicates that we need to find […]
Format cell to show numbers in thousands
Sometimes it is useful to round numbers to the nearest 1000 in order to obtain a good looking report. That is, to have many small width columns and get them all on the same page when printing. Formatting cells to show thousands Right click on the cell you want to format Select Format cells…. From […]
How to use Offset in a table
Need to find a value in a large table and you know only the label of the row and column where the target is located? No problem, Excel can help you do it with only two formulas: Offset and Match. Take a look in the picture bellow. You will find out how to do it. […]
SunSystems Custom VBA Reports
Are you wondering if there is some possibility to extract information from SunSystems database that allow for decisions to be taken without having to ask employees to process the data before presenting it in a standard or custom reporting template? The answer is YES, there is a solution for this and it is called VBA […]