Excel: SUMIFS Function

Excel: SUMIFS Function

Sums the values that meet several conditions at once. All conditions combine with AND, not OR.

N8N: On a Webhook Call Trigger

N8N: On a Webhook Call Trigger

Starts a workflow instantly when an HTTP request hits its URL. Test and production URLs behave differently.

N8N: On a Schedule Trigger

N8N: On a Schedule Trigger

Starts a workflow at fixed times or intervals, like Unix cron. Missed runs are skipped, not backfilled.

SharePoint: UPPER function

SharePoint: UPPER function

Converts text to uppercase, leaving numbers and punctuation untouched. The result is always text.

Excel: Count Function

Excel: Count Function

Counts the cells in a range that contain numbers. Ignores text, blanks, and errors.