Forum Discussion

Francis900's avatar
Francis900
Copper Contributor
Feb 13, 2025
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 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

  • Patrick2788's avatar
    Patrick2788
    Silver 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.