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.
Recent Comments
mindOnion on Drawing a Buckyball in Ex… 
dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… 
Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… 
Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… 
metroxx on Composite Beam Spreadsheet Upd…
Newton Excel Bach, not (just) an Excel Blog 