Count, sum, average and filter cells by background color, font color and style — across sheets too.
정보 업데이트:2026년 10월 5일
호환 기기:
29만+
개요
Stop manually tagging or re-sorting your data just to total up colored cells. Custom Count and Sum adds dozens of custom functions to Google Sheets™ that count, sum, average, find the max, min or median, and filter based on how your cells actually look — background color, font color, and font style (bold, italic, underline, strikethrough).

COLOR & STYLE FUNCTIONS
Sum, count, average, or find the max, min or median of cells by background color, font color, or font style — use a reference cell or a hex code. Combine color AND style in a single condition (e.g. only bold red cells).

CROSS-SHEET FUNCTIONS
Aggregate the same range across every sheet in your spreadsheet with SUMALLSHEETS, COUNTALLSHEETS, AVERAGEALLSHEETS, MAXALLSHEETS, MINALLSHEETS and MEDIANALLSHEETS — no more manually summing tab by tab.

FILTER FUNCTIONS
Spill matching values into a clean vertical array with FILTERBGCOLOR, FILTERFONTCOLOR, FILTERFONTSTYLE and FILTERCOLORANDSTYLE — empty cells excluded automatically.

CHECK FUNCTIONS
ISFONTSTYLE, ISFONTCOLOR, ISBGCOLOR and ISCOLORANDSTYLE return true/false per cell, matching your range's shape — perfect for conditional logic and audits.

Built for anyone who color-codes spreadsheets: project trackers, budget sheets, inventory logs, status boards. If you've ever wished SUM and COUNT understood color, this add-on is for you.

COUNTSTYLE is free on any range, and ISFONTCOLOR / ISBGCOLOR / ISFONTSTYLE / ISCOLORANDSTYLE are free on a single cell. A 14-day free trial unlocks all 38 functions; after it, paid plans (monthly, yearly, or one-time lifetime) keep full access. Licenses are per user, not per domain — a domain-wide install doesn't include full access for every domain user on its own. A separate team plan is available for covering a whole domain. Visit base10addons.dev/custom-count-sum for full pricing, FAQ, and domain-license setup details.

Built by base:10 — practical Sheets add-ons for everyday spreadsheet work.

Google Sheets™ is a trademark of Google LLC.
추가정보
가격유료 기능을 포함한 무료
개발자
개인정보처리방침
Custom Count and Sum에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
Custom Count and Sum에서 Google 계정에 액세스해야 함
이렇게 하면 Custom Count and Sum에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
외부 서비스에 연결
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
Google에서 내 개인 정보를 나와 연결
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴