Google Sheets Counter Formulas

Tallies, party bursts, and celebration rows for milestones.

Counter template

Put a count in A1. Repeats the emoji that many times. No goal bar.

=REPT("👏",A1)

👏👏👏

REPT

Password strength

Put strength 0-5 in A1. Labels Weak, OK, or Strong.

=REPT("█",MIN(A1,B1))&REPT("░",MAX(0,B1-A1))&" "&IF(A1>=4,"Strong",IF(A1>=2,"OK","Weak"))

███░░ OK

REPT IF

Poop races to the toilet

Put checked count 0-10 in A1. Each check pulls 💩 closer to 🚽.

=REPT("·",MIN(A1,B1))&"💩"&REPT("·",MAX(0,B1-A1))&"🚽"

···💩·······🚽

REPT MAX

Coffee cup counter

Put cups drunk 0-5 in A1.

=REPT("☕",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

☕☕☕○○

REPT

Pizza slice tracker

Put slices left in A1.

=REPT("🍕",A1)&" left"

🍕🍕🍕 left

REPT

Ice cream scoops

Put scoop count 0-5 in A1.

=REPT("🍦",MIN(A1,B1))&REPT("·",MAX(0,B1-A1))

🍦🍦🍦··

REPT

Hearts counter

Put love level 0-5 in A1. Filled red hearts show the score.

=REPT("❤️",MIN(A1,B1))&REPT("🤍",MAX(0,B1-A1))

❤️❤️❤️🤍🤍

REPT

Mending hearts counter

Put love level 0-5 in A1. Score 1 is broken, 2-3 mending, 4-5 full hearts.

=IF(A1<=0,REPT("🤍",5),IF(A1=1,REPT("💔",1)&REPT("🤍",4),IF(A1<=3,REPT("❤️‍🩹",A1)&REPT("🤍",MAX(0,B1-A1)),REPT("❤️",A1)&REPT("🤍",MAX(0,B1-A1)))))

❤️‍🩹❤️‍🩹🤍🤍🤍

REPT IF

Hearts white to red counter

Put love level 0-5 in A1. Each slot turns from white to red as the score rises.

=IF(A1>=1,"❤️","🤍")&IF(A1>=2,"❤️","🤍")&IF(A1>=3,"❤️","🤍")&IF(A1>=4,"❤️","🤍")&IF(A1>=5,"❤️","🤍")

❤️❤️❤️🤍🤍

Rainbow hearts counter

Put love level 0-5 in A1. Each filled heart gets its own color.

=IF(A1>=1,"❤️","🤍")&IF(A1>=2,"🧡","🤍")&IF(A1>=3,"💛","🤍")&IF(A1>=4,"💚","🤍")&IF(A1>=5,"💙","🤍")

❤️🧡💛🤍🤍

Taco Tuesday count

Put taco count in A1.

=REPT("🌮",A1)

🌮🌮🌮

REPT

Campfire growth

Put stage 1-4 in A1. Wood, spark, fire, campsite.

=CHOOSE(A1,"🪵","✨","🔥","🏕️")

🔥

CHOOSE

Sick to well recovery

Put stage 1-5 in A1. Sniffles, fever, medicine, doctor, healthy.

=CHOOSE(A1,"🤧","🤒","💊","🩺","😊")

💊

CHOOSE

Birthday candle count

Put age or candle count in A1.

=REPT("🕯",A1)&"🎂"

🕯🕯🕯🎂

REPT

Email inbox pile

Put unread count in A1.

=REPT("📧",A1)&" unread"

📧📧📧 unread

REPT

Piggy bank savings

Put coin count in A1.

=REPT("🐷",1)&REPT("💰",A1)

🐷💰💰💰

REPT

Light bulb ideas

Put idea count 0-5 in A1.

=REPT("💡",MIN(A1,B1))&REPT("○",MAX(0,B1-A1))

💡💡💡○○

REPT

Music note volume

Put note count in A1. Quarter and eighth notes.

=REPT(CHAR(9834),A1)&REPT(CHAR(9835),MAX(0,B1-A1))

♪♪♪♫

REPT MAX CHAR

Game controller lives

Put lives left 0-3 in A1.

=REPT("🎮",MIN(A1,B1))&REPT("✗",MAX(0,B1-A1))

🎮🎮🎮

REPT

Slot machine cherries

Put match count in A1. Cherries vs lemons.

=REPT("🍒",MIN(A1,B1))&REPT("🍋",MAX(0,B1-A1))

🍒🍒🍋

REPT

Brick wall gate

Put build progress 0-10 in A1. Bricks stack toward the gate.

=REPT("🧱",A1)&"🚪"&REPT(CHAR(9617),MAX(0,B1-A1))

🧱🧱🧱🚪░░░░░░░

REPT CHAR

Space base shield

Put shield strength 0-10 in A1. Blocks protect the rocket.

=REPT(CHAR(9608),MIN(A1,B1))&"🚀"&REPT(CHAR(9617),MAX(0,B1-A1))

███🚀░░░░░░░

REPT CHAR

Butterfly garden count

Put butterfly count 0-5 in A1.

=REPT("🦋",MIN(A1,B1))&REPT("🌸",MAX(0,B1-A1))

🦋🦋🦋🌸🌸

REPT

Related formula guides

Go deeper with Better Sheets

Members get full courses on CHAR, REPT, and dashboard design, plus hundreds of Google Sheets tutorials. Copy-paste formulas here stay free.

Unlock playground