To split text in Google Sheets, use the Data > Split Text into Columns menu. Otherwise, use the SPLIT formula. This guide discusses both methods.| Spreadsheet Point
The SUMIFS Google Sheets function can look complex. But, once you understand they syntax, it's easy to use. Follow this simple guide to learn how to use SUMIFS.| Spreadsheet Point
Can Google Sheets group rows and columns? Yes, there are actually a few different ways to do it. Learn them all here.| Spreadsheet Point
Let's talk about how to use VLOOKUP with multiple criteria. After all, I often use this formula to find data based on more than one thing. Fortunately,| Spreadsheet Point
Summing in spreadsheets is simple. But, what if you only want to use specific numbers in a range? That's when you'd use the SUMIF Google Sheets function.| Spreadsheet Point
Learn how to use Google Sheets as a database with this straightforward guide. We also discuss why you should or shouldn't database with spreadsheets.| Spreadsheet Point
Learn to use the Google Sheets QUERY function. This guide walks you through simple and complex QUERY examples with screenshots and a free template.| Spreadsheet Point
To compare two columns in Google Sheets, use a function like COUNTIF or VLOOKUP. Here's how to use spreadsheet functions for comparison.| Spreadsheet Point
Learn how to SUM a column in Google Sheets in no time with the inbuilt SUM Function with this guide’s simple step-by-step instructions.| Spreadsheet Point
Learning which Google Sheets Wildcard to use and when can seem daunting, but this guide makes it simple.| Spreadsheet Point