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.

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 dynamicall‎…

Blog Syndicated with Ian Grieve’s Permission