Tag: spreadsheet tricks

How to Count or Sum Cells by Color in Google Sheets (with Script)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

🎨 How to Count or Sum Cells Based on Cell Color in Google Sheets Google Sheets doesn’t have built-in functions like COUNTBYCOLOR or SUMBYCOLOR, but you can achieve this using Google Apps Script or manual helper columns if using conditional formatting. ✅ Method 1: Using Google Apps Script (Best for Manual Cell Colors) You can…
How to Combine Date and Time in Google Sheets (No Add-ons Needed)

Jun 26, 2025

—

by

Himanshu

in Google Tools Training

📅⏰ How To Combine Date And Time Columns Into One Column In Google Sheets? When working with separate date and time columns, you may need to merge them into a single datetime format. Here’s how to do it effortlessly: ✅ Example Setup A (Date) B (Time) 26/06/2025 10:30 AM You want column C to show:26/06/2025…