Need urgent help

Hi I need a formula to calculate the sum of a data available by weeks(ex 4weeks in a month) in a specific row, condition it should look up for a specific week in a month and provide a total.
Example, Need sum of MTD volumes of week 3, I applied sum if's however was getting the entire sum of a month, would need cumulative analysis