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
Dyn365GP26 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
Dyn365GP25 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
Dyn365GP24 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
Dyn365GP23 April 2024In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
