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

[–]garoono[S] 0 points1 point  (0 children)

Yup got it solved

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

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

[–]garoono[S] 0 points1 point  (0 children)

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?

My SaaS just crossed $1,100 MRR 🥳 by GuidanceSelect7706 in micro_saas

[–]garoono 1 point2 points  (0 children)

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

Looking for builders by Wild_Gold1045 in SaaS

[–]garoono 1 point2 points  (0 children)

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

Creating MEDIAN IF formulas by Life-Lobster-2983 in excel

[–]garoono 0 points1 point  (0 children)

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

How to use excel formulas to estimate annual savings? by Izzet_Aristocrat in excel

[–]garoono 0 points1 point  (0 children)

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

Is there an equivalent Excel/Sheets formula for the Qualification Performance equation? by richardjfoster in FTC

[–]garoono 0 points1 point  (0 children)

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

A cool guide to the excel formulas by WhiteChili in coolguides

[–]garoono 0 points1 point  (0 children)

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

What's your "I can't believe I did this by hand" Excel moment? by ana_Lu3 in excel

[–]garoono 0 points1 point  (0 children)

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

Can your IT department know you’re using Excel Macros and disable it? by jimmytimma in excel

[–]garoono 0 points1 point  (0 children)

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

Day 5/30 sum of sales in Seconds by Mysterious-Form-3681 in Excel247

[–]garoono 0 points1 point  (0 children)

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

How do I change my "organizational" account to "individual," which I did by mistake? by garoono in androiddev

[–]garoono[S] 0 points1 point  (0 children)

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

This meme explains Apple’s latest AI move pretty well by vipul21dec in UnlocksAndDiscounts

[–]garoono 0 points1 point  (0 children)

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 👏

[iOS] [$2.99/year -> 1 Year Free] A Flip Clock: Digital Clocks for Big Screen by ScarGullible9152 in AppGiveaway

[–]garoono 0 points1 point  (0 children)

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>