Skip to content
One Agent a DayIn → agent → out
MenuClose

Tag

Formulas

1 agent tagged Formulas. Related agents on each page prefer a shared tag before they fall back to the same shelf.

  1. Automation20 Oct 2026 · #46Formula WhispererSay what you want a cell to do, in plain words. Get a working Excel or Google Sheets formula, explained piece by piece, plus the edge case that would break it.InGoogle Sheets. Sheet "Invoices", headers in row 1, data from row 2 downOutEdge casesEasy
    Preview this drop
    1. 0:00 The askInvoices sheet: date, client, amount, paid. Wants unpaid total per client, last 30 days only.
    2. 0:08 Function pickedSUMIFS with three conditions. Blank in 'paid' handled by matching anything that isn't 'yes'.
    3. 0:16 Formula=SUMIFS(Invoices!C:C, Invoices!B:B, A2, Invoices!D:D, "<>yes", Invoices!A:A, ">="&TODAY()-30)
    4. 0:24 Edge casesDates stored as text return 0. Client names with trailing spaces won't match. Fix for each included.

    No daily video for this drop yet. The in and out lines above are the preview.

Tomorrow's drop

Get the daily agent

One email when the drop goes up. The same list as the signup on the page.

Opens the beehiiv signup in a new tab. Finish there to join the list.