Google Sheets Functions
Sum If Cell Contains Text in Another Cell in Google Sheets
Learn how to use SUMIF in Google Sheets to add values based on exact text, partial matches, or multiple text conditions with SUMIFS.
Read article
Author & Spreadsheet Consultant
Mohammed Shafin Arshad
111 Articles PublishedPublishing since
Mohammed Shafin Arshad is a Computer Science student and cybersecurity enthusiast in Malaysia with 6 years of Excel and Google Sheets experience. He specializes in VBA, macro automation, and SaaS-focused workflow guides. His background includes university data science projects, and he enjoys using macros to solve complex spreadsheet problems.
Editorial Review
Articles Published by Mohammed Shafin Arshad
Articles by Mohammed Shafin Arshad are developed under the guidance of ExcelInsider’s core training program and are technically reviewed by Nehad Ulfat, lead spreadsheet consultant, to ensure accuracy and user-centric value.
Google Sheets Functions
Google Sheets COUNTIF to Count Cells Not Equal to Text
Learn how to use COUNTIF in Google Sheets to count cells not equal to specific text, multiple values, exclude blanks, and use ARRAYFORMULA.
Read article
Google Sheets Functions
How to Check If a Cell Contains Partial Text in Google Sheets
Learn how to check for partial text in Google Sheets using SEARCH, REGEXMATCH, VLOOKUP, and more to easily match and count text.
Read article
Google Sheets Functions
Google Sheets QUERY with GROUP BY to Summarize Data
Learn how to summarize data in Google Sheets using QUERY with GROUP BY to total, count, and average sales by region efficiently.
Read article
Google Sheets Functions
How to Use Google Sheets QUERY Across Multiple Sheets
Learn how to use Google Sheets QUERY across multiple sheets with IMPORTRANGE, array syntax, and INDIRECT for dynamic data filtering.
Read article
Google Sheets Functions
How to Count Cells That Contain Partial Text in Google Sheets
Learn how to count cells containing partial text in Google Sheets using COUNTIF for specific words or dynamic text from another cell.
Read article
Google Sheets Functions
VLOOKUP to Pull Data from Another Google Sheets Workbook
Learn how to use VLOOKUP to pull data from another Google Sheets workbook, combine with IMPORTRANGE, and fetch data across files.
Read article
Google Sheets Functions
IMPORTRANGE Function to Pull Data from Another Spreadsheet
Learn how to use IMPORTRANGE in Google Sheets to pull data from another spreadsheet, including named ranges and filtered imports.
Read article
Google Sheets Functions
How to Count Cells with Values in Google Sheets (4 Ways)
Learn how to count cells with values in Google Sheets using COUNTA, COUNTIF, COUNT, and COUNTBLANK functions for accurate data tracking.
Read article
Google Sheets Advanced Tutorials
How to Send Emails Based on Cell Values in Google Sheets
Learn how to send emails from Google Sheets based on cell values using Apps Script, triggers, add-ons, or macros.
Read article
Charts in Google Sheets
How to Use SPARKLINE in Google Sheets (with 6 Examples)
Create and customize sparklines in Google Sheets to visually track trends, compare data, and analyze performance metrics with ease.
Read article
Google Sheets Intermediate Tutorials
How to Print Labels from Google Sheets (3 Quick Methods)
Learn how to print labels from Google Sheets using Avery Label Merge, Google Docs with Apps Script, or Microsoft Word.
Read article