Forum Discussion

Himanshuhm's avatar
Himanshuhm
Copper Contributor
Dec 16, 2022

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

excel

1 Reply

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Dec 16, 2022
    Use FILTER() function then sum. Attach a sample file/data and show your desired output.

Resources