9 Replies Latest reply on Jul 18, 2018 3:33 PM by eok

# AVG of SUMs per week in a month

Hello everyone,

I'm relatively new here.

Looking for your help on how to create a formula, that will help me to get the AVG of SUMs per weeks in a given month. Sometimes it there will be 4 weeks, sometimes 5.

Basically, I'm getting data for products A, B, C each week, I want to show AVG of SUMs per week in a given month (each month number of weeks can be different because my batch date is every Friday )

• ###### 1. Re: AVG of SUMs per week in a month

Hi, like this?

• ###### 2. Re: AVG of SUMs per week in a month

Do you have a workbook, A simple sample will Suffice.

Thanks

Deepak

• ###### 4. Re: AVG of SUMs per week in a month

Oh Elya...Not .twb...but .twbx..we can't open .twb ,as  a .twb does not carry data. please attach .twbx

• ###### 5. Re: AVG of SUMs per week in a month

sure. see above

• ###### 6. Re: AVG of SUMs per week in a month

This is What you have in Data?

So what is the Question here??

• ###### 7. Re: AVG of SUMs per week in a month

yes, as you can see dates are the same for each given week. Volume is the same. but from month to month it can be different. I want to show AVG of 4 or 5 n(based on how many dates we have for this particular month)  SUMs in this month.

• ###### 8. Re: AVG of SUMs per week in a month

Hi Elya,

Looks Like You are after This

Thanks

Deepak

If It Helps, Pl mark it Helpful and CORRECT to close Thread

• ###### 9. Re: AVG of SUMs per week in a month

I this case I'm getting the same SUM of volume for each product, but in each product category, I can have a various number of subcategories, each one of them can cave various volumes depend on the season.