There are times you may have hidden data in a spreadsheet. If you use the ‘Sum’ function, you will receive a total based on all the information, including hidden cells. If you would like to see a ‘Sum’ that only includes the visible data, you will need to use a special formula with "Subtotal".