Hi, I have been struggling with a formula for the past 3 weeks.    Here's the situation:   I have a data table with data from 2005 to 2020. I need to extract a single week data from the table so it can become my report. Here's a capture. I want a formula Excel equivalent to a SUMIF(data dates, < my week, SumWeek) in the column Sum Week T-1.   Right now I have this formula that works when no filters are applied.    But when I applied the filters, it starts to sum only on the first row, not the entire data set.   Thank you for your help.   Felix   ... View more