Google Sheets offers many of the same features as Microsoft Excel. The SUMIF function allows you to quickly sum rows that meet certain criteria.

You can add a drop-down list in Google Sheets to better organize data within your spreadsheet. To add a drop-down list, you'll have to use the Data Validation function in Google Sheets.

Now add a new sheet, and type the following formula in cell A1 and hit enter: =TRANSPOSE (Sheet1!A1:C6) Replace the ‘Sheet1’ part with the name of the sheet containing the table. New table ...

You may need to add cells in Google Sheets if your spreadsheet needs to contain more information than it currently has room for.