Excel: SUMIFS Function
Sums the values that meet several conditions at once. All conditions combine with AND, not OR.
Some topics are too broad and complex to cover in a single article. That does not mean I want to skip them, so here I share high-level thoughts about a specific subject. They might spark several follow-up articles or stand alone, but the point is to convey the main idea or concept clearly. I call these overviews because that is exactly what they are. A few sit slightly off brand for this blog, and when they do I still work to make them relatable and engaging while keeping that broad, big-picture mindset so things never get too dense. There is no schedule for these posts. I write them whenever I stumble onto a topic that interests me, so expect them to appear sparingly among the more focused work here.
Sums the values that meet several conditions at once. All conditions combine with AND, not OR.
Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.
Returns the current timestamp plus a number of time units. Always counts from UTC now.
Provider SDKs often pull in dozens of dependencies when a simple HTTP request to the API would do.
Copies a file to another library or site. Version history and metadata don't carry over.
Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.
Starts a workflow at fixed times or intervals, like Unix cron. Missed runs are skipped, not backfilled.
Defines what an AI Agent is, with quick tips for keeping agents constrained, safe, and under your control.
Malcolm Gladwell examines the 'rule of thirds' through cheetahs, sports, and crises in this page-turner.
Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.
A site update on how things are going, plus four new sections and open consulting slots.
Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.