Forum Discussion
Solved
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...
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.
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.