I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
This is based on an example a colleague discussed with me for dynamically calculating the sum of a range of columns based on the user specificed number of months.
The data for the months of the year was going across the worksheet with a total at the end, but he only…
Continue Reading Ian Grieve’s Article on their blog
Excel Snippets: Offset Formula to Calculate Range on Number
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. This is based on an example a colleague discussed with me for dynamically calculating the sum of a range of columns based on the user specificed number of months.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Use a New Role Center for Collection Management
- Dyn365GP6 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Ensure Accurate Inventory Valuation by Controlling Cost Adjustment
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: See Improved Usability for Warehouse and Inventory
- Dyn365GP3 May 2024New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1: Automate the Reminders Process in Collections