Category: Functions in Google Sheets

1. COUNTIF Function Figure 1.1 COUNTIF Scenario 1.1 COUNT with a Condition The COUNT and COUNTA functions are both used to count the total items within a given list. The main difference between the two is that the COUNT function only counts numerical values while the COUNTA can count any data types (e.g., texts, dates,… Continue reading How to Use the COUNTIF function in Google Sheets

1. CONCATENATE Function Figure 1.1 CONCATENATE Scenario 1.1 Stitching Values into One The table in Fig. 1.1 contains two inputs: Last Name and First Name. Column C automatically generates the Full Name from the two inputs by stitching them into one text using the CONCATENATE function. If your task requires stitching values together into one… Continue reading How to Use the CONCATENATE function in Google Sheets

1. VLOOKUP Function Figure 1.1 Data Extraction 1.1 Data Extraction Data analysis and interpretation require an organized and a filtered data set, and most of the time, these processes involve extraction of data. Data extraction in spreadsheets is a simple process of defining the location of a cell or range of cells to extract the… Continue reading How to Use the VLOOKUP function in Google Sheets

1. IFERROR Function Figure 1.1 Types of Error  1.1 Types of Errors Spreadsheet formulas have rules and properties when it comes to their syntax, inputs and processes. If the required rules and properties are not satisfied, the formulas return an error code depending on the cause of the error (Fig. 1.1). Let’s look at the… Continue reading How to use the IFERROR function in Google Sheets

1. IF Function Figure 1.1 Conditional Statement 1.1 Conditional Statement          Conditional statements are a way for us to automate tasks that involve decisions. Most of the scenarios that we’ll encounter in the spreadsheets will involve some sort of testing or checking conditions. A lot of calculations and other processes require criteria that needs to… Continue reading How to use the IF function in Google Sheets

1. SUMIF Function Figure 1.1 SUMIF Scenario 1.1 SUM with a Condition The SUM function is a powerful function that calculates the total amount for a given range of cells, but what if we only want to calculate the total amount for a specific set of cells within a list? Let’s say we want the… Continue reading How to Use the SUMIF function in Google Sheets

1. INDIRECT Function 1.1 Dynamic References          Most of our data sets are dynamic, and we want the changes in range size or sheets reflected in our formulas. While the former is easier to implement, the latter is more challenging because most functions are dependent on cells and not the sheets. There are a lot… Continue reading How to use the INDIRECT function in Google Sheets

1. IMPORTRANGE Function Figure 1.1 Data Extraction from a different Workbook 1.1 Data Extraction Most of the time our data may come from different sources such as different Google Spreadsheets or Workbooks, and the usual problem is how to consolidate all of these data from different workbooks into one. We can do this manually, but… Continue reading How to use the IMPORTRANGE function in Google Sheets

1. INDEX-MATCH Formula 1.1 Data Extraction          Data extraction is one of the most common data manipulation processes in the spreadsheet. The extractions can range from a simple extraction of data to conditional extraction. Values within a range or an array are mapped using their row and column coordinates. Therefore, the main problem encountered in… Continue reading How to Use INDEX and MATCH together in Google Sheets

1. TRANSPOSE Function 1.1 Reorganization of Data   Data reorganization in spreadsheets is one of the common data manipulation processes, especially if we want to make a meaningful summary. There are times where we want to change the presentation of the data by converting one of the variables from the data to a different orientation.… Continue reading How to use the TRANSPOSE function in Google Sheets