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
A Very Short Article… on Is Hinchliffe’s Rule Tru… 
dougaj4 on Using LinEst() on data with… 
Chris on Using LinEst() on data with… dougaj4 on Using LinEst() on data with… Chris on Using LinEst() on data with… dougaj4 on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … 
Sunny on Concrete ULS spreadsheet … dougaj4 on Concrete ULS spreadsheet … Sunny on Concrete ULS spreadsheet … Using Numba with Exc… on Two Timers 
masood bhatti on Deflections and Moments in Rec… Kapasitas Lateral Ti… on LatPile – Analysis of La… 
mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness…
