Tips, tutorials, and training
There are several different ways to count cells in Google Sheets conditionally. However, most techniques look for a positive match to a condition. Let’s explore the opposite, where we count cells that do not match a condition. Follow along with these examples using this live spreadsheet. We will be using COUNTIF in these examples, which … Read more
The COUNTIFS function is used in Google Sheets to count cells if they meet specific conditions. COUNTIFS checks cells for conditions and then counts every cell that meets the criteria. Use the COUNTIF function if you have only one criterion. Get your copy of these examples in a live Google Sheet. Purpose This function returns … Read more
The SUMIFS function is used in Google Sheets to add numbers if multiple conditions are true. SUMIFS checks for the conditions then adds values if those conditions are TRUE. Remember that all conditions must be met for the function to sum a value, and all ranges must be the same size. You can use SUMIF … Read more
The SUMIF function is used in Google Sheets to add numbers if data meets a specific condition. SUMIF checks for a condition then adds a value if that condition is TRUE. Use SUMIFS to check for multiple conditions. Feel free to copy the template with these examples to follow along. Purpose This function returns the total of … Read more