My post from last week, on using the Aggregate function to find the maximum and minimum of a range ignoring errors, was linked in the Contextures Blog’s weekly roundup, which also linked to the Contextures page of Sum Function examples.  This includes sub-totals, grand-totals, Offsets, Sumifs, Sumproducts, and much more.  It’s a comprehensive list, including clear examples and videos, and well worth a visit.

The Contextures Blog on Sums