Been a long time... Array or Index (I forget)

[Kaloyanides]

It's been a long time since I've done this. I can't remember how to do it and I can't seem to google the solution.

The first two columns are linked to another sheet. I'll end up hiding the first two columns.

I want the columns WEEK and TOTAL SALES to automatically condense so I can use to create a chart.

I think an Array, right? I have to hold SHIFT and CTRL and hit ENTER? If you're able to help with the formula, I'd be SUPER grateful. Thanks!

 

[Legacy 143009]

How about to use SUMIF function? Not an array formula:

=SUMIF(week_range,week_number,sales_range)

 

[Kaloyanides]

You're the best! Thanks so much!!!

 

[Legacy 143009]

You are welcome Thanks for the feedback