Google Spreadsheets can be mundane to look at, with all those numbers just sitting there staring at you in black and white. It’s easy to fall into a vortex of numbers determining what number goes where, totals, what needs to be done, dates, and so on.
How to keep it all straight? Just as with text documents, color and formatting are your friends; conditional formatting makes it easy.
The tabs feature in Google Sheets is a great organizational tool, and it keeps thing neat and tidy. However, sometimes we need a summary spreadsheet, an at-a-glance overview of the data. Or perhaps it’s useful to see a single chart that updates as we add new information. In either case, the quickest solution is to use the =SUMIF function, and it’s easier than it initially appears.
As an example, let’s create a summarized list of the trucking suppliers we pay. First, add a new tab to the Google Sheet that records the column headers that match the information to summarize.