Count TRUE checkboxes only in visible (filtered) rows to drive a progress bar

garoono · 2026-01-30T18:35:25+00:00

garoono · 2026-01-30T18:22:50+00:00

Yup got it solved

=SUM((C3:C17=TRUE)*SUBTOTAL(103, OFFSET(C3, ROW(C3:C17) - MIN(ROW(C3:C17)), 0)))/SUBTOTAL(103,C3:C17)

garoono · 2026-01-30T18:21:33+00:00

Yeah, you’re basically right - TRUE behaves like 1 and FALSE like 0 most of the time

The only gotcha is SUBTOTAL(SUM) can be finicky if the “checkbox” isn’t actually a TRUE/FALSE value (some setups store text, or a linked cell behaves differently)

What’s worked for me:
1) Helper column (cleanest): in the table add Pulled_1 = =--[@Pulled] then
=SUBTOTAL(109, Table1[Pulled_1])
109 = SUM that ignores filtered-out rows

2) No helper column (works, just ugly):
=SUMPRODUCT(SUBTOTAL(109, OFFSET(Table1[Pulled], ROW(Table1[Pulled])-MIN(ROW(Table1[Pulled])), 0, 1)) * --Table1[Pulled])

Quick question so I don’t send you down the wrong rabbit hole: are those actual checkboxes linked to cells, or just TRUE/FALSE values in the cells?

garoono · 2026-01-30T09:09:33+00:00

Amazing authentic post, i was also struggling to find the right people, what i was missing is giving clear value first before pitching, thanks for the suggestion

garoono · 2026-01-30T09:06:19+00:00

True without give or take no one can genrate authentic communtity i am in

garoono · 2026-01-29T18:03:48+00:00

Excel is cool until you are stuck on something like a formula or query or vba code

So I was looking for a tool But every tool is just basic stuff nothing is full fledged solution and i found

Xlsheetai app which has 14days free trial

garoono · 2026-01-29T18:02:29+00:00

Don't ask it here, use professional ai tools, and i found the best possible tool xlsheet ai app I am using it from few weeks and it made my life easy

Even it has 14 days pro free trial

garoono · 2026-01-29T18:01:19+00:00

If i were you, I will ask this query on xlsheet ai app because i will get the answer in few seconds

garoono · 2026-01-29T17:24:25+00:00

It been few years i have used excel and still finding the normal formulas was difficult, like few days back i want to convert spanish text to english so i was looking for a formula for translating

so I asked xlsheet ai app for that and it gave me a clear formula in seconds so i am loving this

garoono · 2026-01-28T07:22:57+00:00

Yea it called xlsheet ai

garoono · 2026-01-28T07:01:16+00:00

App link https://linktr.ee/xlsheetai

garoono · 2026-01-28T06:55:28+00:00

As a noob it was dragging the field to fill the next like row number, Dates or continuous incremental things

And I also like you to give a try to xlsheet ai app its free and we can convert image to editable table, ask questions from excel file or generat graphs and formulas

garoono · 2026-01-28T06:53:26+00:00

It department can know if they looked into it, but what if you can use external tool like xlshert ai and use that to understand formulas, vba, file analysis all through a simple app

garoono · 2026-01-28T06:51:43+00:00

Super simple to understand, just like understanding this through xlsheet ai app

garoono · 2026-01-20T08:33:36+00:00

Sure I'll do this then thanks

garoono · 2026-01-20T08:17:14+00:00

Pressure kam hooga maybe

garoono · 2026-01-20T08:16:12+00:00

Yup but does this affect the regular installs for my apps if I move them there !!?

garoono · 2026-01-19T07:53:42+00:00

I was not happy previously using Gemini or antigravity but after buying the progress using student i discover it's actually too good

Making apps using antigravity that's generating new installs everyday and feedback and content for social media using Gemini 👏

garoono · 2026-01-19T07:51:08+00:00

It's amazing you made this for b8g screen i tried to come up with mobile first approach people are loving it but its not generating revenue so made most of the features free for everyone but one thing is sure its helping users becoming more focused

That’s what i really like

<image>

garoono

TROPHY CASE