Forum Discussion
Adding values in an array between 2 specified matches
Hi
I am working on a cost forecasting spreadsheet. I want to sum the costs over a specified period from a start week to an end week. The data is in the forma of a table with week numbers on the top and costs in rows for different departments.
I can get the index for the specific columns that match the week numbers I want, but how do i use that or something else to only sum the costs over the period specified by the 2 week numbers
Many Thanks
Francis
I understand what you're looking for but since there's no sample data I've created my own. Please note this solution utilizes a recent innovation in Excel to trim ranges to easily create dynamic named items. Please see attached workbook.
1 Reply
- Patrick2788Silver Contributor
I understand what you're looking for but since there's no sample data I've created my own. Please note this solution utilizes a recent innovation in Excel to trim ranges to easily create dynamic named items. Please see attached workbook.