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.
Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Calling Add-in functions from VBA
- About Newton Excel Bach
- Beam actions and deflections by Macaulay's Method
Recent Comments